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