Count Formula

[Annie]

Hello,

I'm having trouble posting, so please forgive me if you get this reuqest
more than once.

I have a form in Excel that has a check box in rows F8:F27. If you click on
the box a check mark will appear. What formula do I use to count the number
of boxes checked?

 

[Pete_UK]

Try this:

=COUNTIF(F8:F27,"<>")

Hope this helps.

Pete

 

[p45cal]

Hello,

I'm having trouble posting, so please forgive me if you get thi
reuqest
more than once.

I have a form in Excel that has a check box in rows F8:F27. If yo
click on
the box a check mark will appear. What formula do I use to count th
number
of boxes checked?

Do each of these chackboxes have their 'Linked Cell' set to a cell?
If so, then a formula which looks at the cells can give you you
count:
=COUNTIF(E8:E12,TRUE)
where E8:E12 are the linked cells