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

Chris,
The problem with your formula is related to the inch designation ("). My suggestion is to remove that ", rename your column title to something like "Plate Size (Inches)" so that the column data consists of numbers (57, 64). Then remove all of the "'s from your formula, becoming =SUMIF([Plate Size]:[Plate Size], 57, [# of Plates Made]:[# of Plates Made]). It should work for you now.
There may be a way for it work with 57", but honestly I don't think it is worth the time and effort to figure it out.
Steve
Answers

Chris,
The problem with your formula is related to the inch designation ("). My suggestion is to remove that ", rename your column title to something like "Plate Size (Inches)" so that the column data consists of numbers (57, 64). Then remove all of the "'s from your formula, becoming =SUMIF([Plate Size]:[Plate Size], 57, [# of Plates Made]:[# of Plates Made]). It should work for you now.
There may be a way for it work with 57", but honestly I don't think it is worth the time and effort to figure it out.
Steve

That works, Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!