SUMIF with a checkbox

declark

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.

Hollie Green

Try IF([payment voucher]@row=0,Sum([Parking Revenue Regular]@row:[Private boat parking revenue]@row),"")

Hollie Green

Try IF([payment voucher]@row=0,Sum([Parking Revenue Regular]@row:[Private boat parking revenue]@row),"")

declark

That worked! Thank-you,

Dan