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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!