SUMIF formula not working, can't see why...
I've been messing with this for an hour and going crazy. Can anyone see the problem? Or suggest an alternative formula?
The formula =SUMIF({8. FY24 FSS Travel Tracking Total Cost}, Appropriation@row, {8. FY24 FSS Travel Tracking Log ARU})
It is located in the cell that's been circled.
It is referencing columns on this sheet.
Best Answers
-
I think you just need to change around your cross sheet references:
=SUMIF({8. FY24 FSS Travel Tracking Log ARU}, Appropriation@row,{8. FY24 FSS Travel Tracking Total Cost} )
-
Hi @Stephanie Allison, it's not clear what your evaluation range is:
{8. FY24 FSS Travel Tracking Log ARU}
From what I can see, this should point to the column "Appropriate Code (select)" if you want to match it with Appropriation@row in your first sheet. However, if you are trying to sum all the items that match "2000 - Travel" AND "051101101 - School Fin GF", you should use SUMIFS instead:
=SUMIFS({FY24Log_AppopriationCodeSelector}, Appropriation@row, {FY24Log_ObjectType}, [Object Type (Ex)]@row)
Assuming that {FY24Log_ObjectType} is a column that contains data equivalent to "Object Type" on the source page.
Answers
-
I think you just need to change around your cross sheet references:
=SUMIF({8. FY24 FSS Travel Tracking Log ARU}, Appropriation@row,{8. FY24 FSS Travel Tracking Total Cost} )
-
Hi @Stephanie Allison, it's not clear what your evaluation range is:
{8. FY24 FSS Travel Tracking Log ARU}
From what I can see, this should point to the column "Appropriate Code (select)" if you want to match it with Appropriation@row in your first sheet. However, if you are trying to sum all the items that match "2000 - Travel" AND "051101101 - School Fin GF", you should use SUMIFS instead:
=SUMIFS({FY24Log_AppopriationCodeSelector}, Appropriation@row, {FY24Log_ObjectType}, [Object Type (Ex)]@row)
Assuming that {FY24Log_ObjectType} is a column that contains data equivalent to "Object Type" on the source page.
-
@Leibel S Thank you so much! works like a charm.
@Lucas Rayala Thank you! I don't need a second criteria for this formula. Funny, I find sumifs much easier than sumif....
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!