Help with a SUMIF statement but it gives me UNPARSEABLE

I have the following SUMIF statement on the top row of the column - =SUMIF([Plate Size]:[Plate Size], "57""", [# of Plates Made]:[# of Plates Made])

If I change it to the following it works but the problem with this is I have rows that do not have data in them yet and I am not sure if it calculates the newly added data if the data above this row is currently empty?

It calculates the rows below correctly even if the rows are empty though


=SUMIF([Plate Size]:[Plate Size], [Plate Size]@row, [# of Plates Made]:[# of Plates Made])

Screenshot attached.

Best Answer

Answers

  • That works, Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!