SUMIF with a checkbox

I'm trying to sum a row of amounts (Parking Revenue Regular:Private boat parking revenue) into the column "Total Parking Revenue", but only if the checkbox "Payment Voucher" isn't checked. When I add the rows using this formula without the checkbox, it works (formula on first row only):

=SUM([Parking Revenue Regular]@row:[Private boat parking revenue]@row)


When I add in the check box with a SUMIF formula, it doesn't work (formula in first row only):

=SUMIF([Payment voucher]@row = 0, [Parking Revenue Regular]@row:[Private boat parking revenue]@row)

It displays "$0.00" with or without the Payment voucher being checked.

I can't figure out what is wrong.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!