formula required for excel 2002
 

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

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

=COUNTIF(F9:F28,"a")

--
HTH

Bob Phillips

"jmlsav2" wrote in message
...
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

THANKS BOB THATS GREAT HELP

"Bob Phillips" wrote:

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

=COUNTIF(F9:F28,"a")

--
HTH

Bob Phillips

"jmlsav2" wrote in message
...
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