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

Importing Excel Workbook with formula @SUMIF - not working



5 commenti

  • Isabel Messore

    Welcome to the Community Jonathan Santamaria!

    The thing to check out is if all of column M and column E are formatted as Dates and not Text.  My gut say they are not, because one is left aligned the other is right aligned. Let me know if this helps!
  • Jonathan Santamaria

    Thank you Isabel Messore.

    Yes, verified all formats are in-line and consistent.  Formats in use are "dates" for dates and "accounting" for the numbers and "text" for the labels.  Still no results on the SUMIF formulas.

    As to the alignment, one thing we are noticing when we import, the alignment that comes in to Workiva workbook are not consistent with what's or how displayed in Excel.  Some numbers and dates in Workiva go in to left alignment while in Excel all these cells are in right alignment.

    Hopefully, you have more insight on troubleshooting the SUMIF formula issue.

    Also, goes out to the Community for any help on the formula and alignment issues.  Thanks.

  • Isabel Messore

    Hmmm very interesting Jonathan Santamaria,

    My initial thought was that it was a circular error, but that doesn't seem to be the case either. You could try clearing that cell and typing in the formula again, instead of relying on the import result. If that doesn't work, I've connect you with Support. They will be able to provide a more in depth analysis of the issue you're facing. Hang tight!

  • Maria Ortega

    Hi! I have the same problem, the SUMIF formula doesn't work, there is any new insights about this?

  • Tyler Ferdinand

    Hi Maria,

    Unfortunately, there are no new insights on this subject matter.

    Please reach out to Support if the SUMIF formula continues to cause you problems.

    Have a good rest of your day!



Accedi per aggiungere un commento.