Try this:

With
A1:A1000 containing various numbers

This formula returns the count of cells with a value of 11

B1: =COUNTIF(A1:A1000,11)

OR....you could enter 11 in cell C1 and use
B1: =COUNTIF(A1:A1000,C1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Arne Hegefors" wrote:

Hi! I have a long list of numbers ranging from -100 to 100. The list contains
many thousands of numbers. I want to count the number of cells containing eg
the number 11. How can I do this?