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.
