Help with a SUMIF statement but it gives me UNPARSEABLE

Chris Kidd

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.

steven.reed14881

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

steven.reed14881

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

Chris Kidd

That works, Thanks!