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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!