SUMIF formula help


My question is will the SUMIF formula work if the cells I want to sum are in 3 adjacent columns?

Here is my formula:

=SUMIF([Corner Y/N]@row, 1, [B-1 QTY-Andy]@row:[B-3 QTY-Andy]@row)

I am trying to sum 3 cells if the meet a checkbox criteria but it is not working. Can anyone see anything wrong?

Here is what the sheet looks like as well.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!