IPad – Calculate sum of true/false checkbox cells

ipadnumbers

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?

Best Answer

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.

Related Solutions

Sum yearly totals automatically

Insert a column between column A and B (you can hide this column after).
Fill the cells of this column with the following formulae:
```
YEAR(A2)
```
The column should be A for all cells, and the row number should be incrementing, such that the cell being referred to is always the one immediately to the left.
In column D, fill the following formulae:
```
SUMIF(Year,"=2015",Amount)
```
Replace ‘Year’ with the column heading for the column you created in step 1.
Replace ‘2015’ with the year that you are looking to be summed for that cell.
Hide the column you created in step 1 (right-click on the column and choose Hide Column).

Numbers – Conditional Sum

Ok, so it's something like this

SUMIF(B2:B37,"=IP",C2:C37)

Where B is the text column to test,=IP is the test condition, C are the values to sum.

Best Answer

Related Solutions

Sum yearly totals automatically

Numbers – Conditional Sum

Related Question