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
Check out the Formula Handbook template!