# 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

Tags:

• ✭✭✭✭✭✭

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!