SumIF Cross Sheet
I am simply trying to summarize AR data for a dashboard on a summary sheet. I need to know the balance due for each company totaled up. Below is one of many attempts I have tried. There are only six options so I canmanually update the formaula for each company but that didnt work either. What am I messing up? Thank You
Answers
-
I don't think there is suppose to be an = sign before Company@row. Should look like
=SUMIF({IBIG Accounts Receivable Range 2},Company@row, {IBIG Accounts Receivable Range 3})
-
Updated it but still cant get anything but zero?I've tried everything I can think of. I am sure it is something stupid, but cannot figure it out
-
Hi @IrohGroup1
Can I clarify what your two ranges are looking at? SUMIF and SUMIFS (plural) have opposite structures. In a SUMIF (singular) statement, the range to SUM goes at the end:
SUMIF(range, criterion, sum_range)
In a SUMIFS (plural), then the SUM range is the first one in the list. Can you confirm that your structure is as follows:
=SUMIF({Company Column}, Company@row, {Column to SUM})
If this isn't the issue, then it's possible that the formula either isn't finding the criteria (the "Company" is spelled differently between the sheets), or that the SUM range is somehow not seen as Numerical. What type of column is the one that has the balance due? Is there a formula in that column that could be converting your balance into text instead of numbers?
Cheers!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!