Need help with a SUMIFS function

Mark Mayers

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

Paul Newcome

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

Mark Mayers

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

Paul Newcome

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

Mark Mayers

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

Paul Newcome

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.