Count Formula
 

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?
--
Thanks, Annie

Count Formula
 

Try this:

=COUNTIF(F8:F27,"<")

Hope this helps.

Pete

On Nov 17, 5:48*am, Annie wrote:
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?
--
Thanks, Annie