Need help with a SUMIFS function
Hi All
I need a bit of help with a SUMIFS formula. What im trying to do is: Source sheet is called "KPI Master data". On a new sheet i am trying to input a formula that will subtract column 4 against column 3 if the date was yesterday in column 1
So far i can get it to work just by looking at a cell
=SUMIFS({KPI Master data Range 1}  {KPI Master data Range 2}, {KPI Master data Range 3}, TODAY(1))
This returns "7" the correct answer, but obviously when more data is entered the formula will break. so need to evaluate columns
Any help would be very appreciated
Answers

You would write two separate SUMIFS. One for column 3 and one for column 4 and then subtract one from the other.

Ok, another question now. Say the column "Lead Name" has multiple names in how would i create a SUMIFS to only look for "Andrew Pask".

Do you mean multiple names in a single cell or multiple cells with single names?

So on another sheet i am trying to do a sum of column 4  column 3 if it was yesterdays date in column 1 and the name is Andrew Pask in column 2
so it should show "7" because 17th was yesterday and Andrew Pask had 10 safety cards subtracting a target of 3

So multiple cells within the column each having a single name.
You would include a range/criteria set within each SUMIFS to evaluate the name column being equal to the name you want to filter by much like you did a range for the dates and then acriteria for the dates.
Help Article Resources
Categories
Check out the Formula Handbook template!