Counting the number of check boxes

Please, can some help I have a sheet that uses check boxes and trying to count the number of boxes in that have been ticked. I am using this formula however it just returns a value of count 0

Any Ideas

="Count: " + COUNTIF(CHILDREN(Sent47:Sent1), 1)

Find more posts tagged with

Formulas

Comments

J. Craig Williams

Andrew,

Try this:

="Count: " + COUNTIF(Sent1:Sent47), 1)

The use of CHILDREN in this case appears to be where the problem lies.

This will count only rows 1 to 47.

If you want the whole Sent row

="Count: " + COUNTIF(Sent:Sent), 1)

as long as your formula is in a different row.

Craig