Calculate sum of true/false checkbox cells I can add true/false buttons ok. I wish to have these buttons equal a number when it's ticked then be added to a total.

I'm brand new to numbers but finding my way ok so far. I do team sheets. Each member pays £2 I wish to just use a tick box to confirm they have paid then total what the true buttons.

Can it be done?
To calculate the sum of the checkboxes, where checked is 1 and unchecked is 0, use:

=COUNTIF(A, true)


Replace A with the range of cells where the checkboxes are.



You can combine this with ×2 to multiply the answer by 2, then format as currency.