Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Excel =SUMIF(RANGE) formula not working when Imported.

0

Comments

2 comments

  • Liz Walters

    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
  • Chuck

    Liz Walters

    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

    0

Please sign in to leave a comment.