Arne,

You can use a rounding function. FLOOR(x, 10) will return 0 for all
numbers in [0, 10), 10 for all in [10, 20) etc.

=SUMPRODUCT(--(FLOOR(A1:A1000,10)=10))

HTH
Kostis Vezerides

On Feb 13, 7:24 pm, Arne Hegefors
wrote:
Thanks! However since the numbers range from -100 to 100 I want to group them
first. Lets say i want to group the numbers in 10s. how can i do that? help
very much appreciated!

"Ron Coderre" skrev:

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?