You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
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
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
Thank you both!
How to SUM only checked checkboxes in a column
