Hi,
I was unable to find this anywhere, so:
In Numbers, I have a column of checkboxes. At the bottom, I'd like to see how many of the checkboxes in the column are checked.
Thanks,
Roman
Numbers 4.1.1.
MacBook Pro, Mac OS X (10.7), 2.26 GHz Intel Core 2 Duo
You can use COUNTIF, like this:
=COUNTIF(B,TRUE)
In the example row 7 is defined as a Footer Row.
And if you want to sum a column, you could do something like this:
=SUMIF(B,TRUE,C)
SG
Thank you both!
is the checkboxes are in column C, then you can get the count of checked boxes like this:
=countif(C, TRUE)
you should put this formula in the a header or footer row
How to SUM only checked checkboxes in a column
