Importing Excel Workbook with formula @SUMIF - not working
We're importing workbooks, all formulas are working except for the SumIF and SumIFs. After reading some of the posts similar to what we are experiencing. We need help since we are unable to make SumIF/s work. Below are screenshots of the SumIF formula and corresponding range and references. Appreciate any help.
-
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!
0
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.
0
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!
0
Hi! I have the same problem, the SUMIF formula doesn't work, there is any new insights about this?
0
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!
0サインインしてコメントを残してください。
コメント
5件のコメント