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

J

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.
 
M

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
 
Top