count of item in excel workshop
 

The only function that may work for you is the COUNTIF(<Range,<Criteria)
function to count the number of occurences that meets the criteria or the
SUMIF(<Criteria Range,<Criteria,[<Sum Range]) function to sum up the
total of the values based on the criteria that has been met.

Note: <Criteria Range is just the range that the <Criteria argument is
ran against, though if <Sum Range is left out, then what's in <Criteria
Range gets summed up for those values that met criteria.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"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