Question

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 · Accepted Answer

@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 · Accepted Answer

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.