Sumifs cross sheet

Nathan Betters

Hello,

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

1. I want to match the project row in my consolidation sheet with the expense sheet (to determine row being calculated)
2. I then want to only look at expense lines that are "Completed" (no more expenses are expected on the line)
3. 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

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

Paul Newcome

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