formula required for excel 2002

J

jmlsav2

hi all,
require some assistance for formating a cell group ie F9:F28 that
will count a symbol i.e.( a tick or cross) instead of a numeral and total it
at the bottom.at F29.

thanks in advance
jml
 
B

Bob Phillips

Are you use a special font (like Marlett) and a letter (a) for the tick? If
so, just use COUNTIF

=COUNTIF(F9:F28,"a")
 
J

jmlsav2

THANKS BOB THATS GREAT HELP

Bob Phillips said:
Are you use a special font (like Marlett) and a letter (a) for the tick? If
so, just use COUNTIF

=COUNTIF(F9:F28,"a")
Click to expand...
 
Top