Excel =SUMIF(RANGE) formula not working when Imported.
If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "TD", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "TD."
Is there a workaround so that this =SUMIF(Range) formula will work when using the "Import" functionality? I have suggested using Wdesk Sync function but with doing so we would lose the data trail we would like to maintain.
-
Hi Chuck,
Thank you for your question and your patience while we looked into this. Can you elaborate on the issues you're experiencing when you are importing the SUMIF formula? I attempted importing an xlsx file using an example like the one you provided and found it to be successful. Knowing a little bit more about your situation will help me find the right guidance for you.
Looking forward to hearing from you!
0
From my experience, the issue arises when I use a SUMIFS function in excel with a range of criteria
e.g =SUM(SUMIFS('E&R Lob Data'!$E:$E,'E&R Lob Data'!$A:$A,$Q506,'E&R Lob Data'!$B:$B,C$501,'E&R Lob Data'!$D:$D,$R506:$X506))
Without the range, the function works okay in Wdesk. I think, prior to excel 2016, the function would have need an array style setup so maybe this is the issue
0Zaloguj się, aby dodać komentarz.
Komentarze
Komentarze: 2