Need help with a SUMIFS function

Options

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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!