count of item in excel workshop
 

if you want the number of cells that contain the single letter R

=Countif(A5:L31,"R")

if you want the number that contain an R

=Countif(A5:L31,"*R*")

This is not case sensitive.

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
Hello all,

Is there a way to count the amount of a specific item "ie.
R" in XL2000. I am presently playing with the =COUNTA
(A5:L31) or =COUNT(A5:L31) functions to no avail

any help is greatly appreciated

cheers
Chris