Let's say the worksheet containing the data is called data. In another
worksheet list your desired values in column A in cells A1 thru A50. In B1
enter:

=COUNTIF(data!$1:$65536,A1) and copy down. Adjust the 65536 if you are
using 2007.
--
Gary''s Student - gsnu200762


"JC in Aus" wrote:

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.