Related to "Counting cells..." (post below)

[jimbob]

I have a range of cells with values that range from (approx) .3 to 2.5. There are about 4600 cells with data. Is there a way to caluculate how prevalent each number is with, say a range of .5? In other words, I want to calculate how often a value of greater than .5 and less than 1.0 occurs. Or greater than 0, but less than.5 and so on.

[mrice]

There are several ways of doing this....

A nice simple one is to use the countif function. If you calculate the number of times a threshold is exceeded for two different thresholds, the number between is simply the difference between the two

e.g. =countif("A1:A4600",">0")-countif("A1:A4600",">0.5")

will give you the count > 0 and <= 0.5