counting Non-text/Non-numerical entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form for use in collecting monthly statistical information at our counseling center. I created a column to collect whether a counseling session is the very first for a client. I did this with a check box. I would like to be able to count the number of boxes that are checked, but I have been able to find a formula that will do that. If I do a simple count it yields nothing because there are no numbers. If I count non-empty cells, it counts them all (I guess because of the box itself). Can anyboday tell me how to do this? Thanks.
 
If the checkboxes are linked to cells, the cells will contain either TRUE or
FALSE. If they aren't linked to cells, I don't think your count of non-empty
cells would have resulted how it did.

You can count TRUEs in that range like =COUNTIF(A1:A999,TRUE).



Chris O said:
I have created a form for use in collecting monthly statistical
Click to expand...
information at our counseling center. I created a column to collect whether
a counseling session is the very first for a client. I did this with a
check box. I would like to be able to count the number of boxes that are
checked, but I have been able to find a formula that will do that. If I do
a simple count it yields nothing because there are no numbers. If I count
non-empty cells, it counts them all (I guess because of the box itself).
Can anyboday tell me how to do this? Thanks.
 
Back
Top