SUMIF formula not working, can't see why...

Stephanie Allison

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.

Leibel S

@Stephanie Allison

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} )

Lucas Rayala

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

@Stephanie Allison

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} )

Lucas Rayala

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.

Stephanie Allison

@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....