Counting symbols

[Joni]

Hello, Quite an urgent problem.

I have inserted check boxes for users to 'tick' if they have a specifi
requirement for that customer.
Two columns both containing a check box for 30 lines.

I would like to count at the bottom how many ticks are in each colum
but I am finding it impossible to count either ticked check boxes o
any other type of symbol? Is it possible?

I've tried excel manuals, 'help', windows excel site etc. Any tip
would be greatly appreciated!

thanks
Jon

 

[Jason Morin]

Typically check boxes are linked to cells, and return
TRUE if the cell is ticked, and FALSE if it is not. You
need to count this range of cells. For example:

=COUNTIF(A1:A10,TRUE)

HTH
Jason
Atlanta, GA

 

[Joni]

Brilliant...I didnt have them linked before so I have done that and jus
hidden the true/false columns.

thanks!!!