=COUNTIF(A1:E600,11)

for example

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JC in Aus" <JC in wrote in message
...
For instance, if I have a worksheet which has 3000 cells with difference
numbers in each, how can i report on how many cells contain the number 11,
and so on?

I want to report on around 50 numbers, and show how many times all 50
numbers appear in the worksheet in some sort of report.

Would really appreciate it if someone could help.