Sumifs cross sheet

Question

Hello,

I am trying to pull in project expenses from an expense tracking sheet, based on multiple criteria.

* I want to match the project row in my consolidation sheet with the expense sheet (to determine row being calculated)
* I then want to only look at expense lines that are "Completed" (no more expenses are expected on the line)
* Then sum all the rows that meet those criteria

I tried the sumifs formula and I am getting an error.  I made a video to show what I did

https://www.screencast.com/t/mMDI22DHH21

And heres the formula I used

=SUMIFS({Project Name}, [Primary Column]@row, {Project Expense Tracking Expense status Completed}, "Completed", {Project Expense Tracking budget actual spend})

Paul Newcome · Accepted Answer

When using SUMIFS (with the S on the end), the range to sum comes first.

=SUMIFS({Project Expense Tracking budget actual spend}, {Project Name}, [Primary Column]@row, {Project Expense Tracking Expense status Completed}, "Completed")