Sounds like a job for DCOUNT - see formula help....


-----Original 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 ...

.