=COUNTIF(A1:A1000,"S0459")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Monk" wrote in message
...
Hi ..

Which is the best function to use if I wanted to return the total number
of
times a word or number (criteria) is used within a specified number of
cells
..?

Example : The product code 'S0459' is used (mentioned) 'X' amount of
times
within an entire column (specified cells)

Thanks in advance ...