I have a simple table of 99 names in column 1 and a column of checkboxes to keep track of whether they answered an invitation--I want a count of number of checkboxes at bottom of column that I have checked--
iMac 27″, macOS 15.1
This is trivial with the COUNTIF() function.
COUNTIF() counts the number of cells in a range that match a value - in this case, just provide the range of checkboxes (e.g. column B) and the value TRUE, and it will count how many checkboxes are set:
=COUNTIF(B, true)
In this case, my table has one footer row, which is excluded from the count, so I can just specify all of Column B for the check.
This is trivial with the COUNTIF() function.
COUNTIF() counts the number of cells in a range that match a value - in this case, just provide the range of checkboxes (e.g. column B) and the value TRUE, and it will count how many checkboxes are set:
=COUNTIF(B, true)
In this case, my table has one footer row, which is excluded from the count, so I can just specify all of Column B for the check.
You could take a look at the Numbers "Sum Checklist" template:
Paul.
Thank you, Paul for answering me--maybe I wasn't clear--I want a count in bottom of the check box column of the total that are checked--in your example in row 7 directly under the Yes/No column---
Hank
Numbers table count of checkboxes in column
