Count Formula

[Jason]

Greetings,

I have a column of data that looks similar to the
following:

0.24
0.75
1.24
0.13
0.98
1.36
0.43
0.57

Could someone please help me with a formula that could
look at all values in the column and then return the
number of values that lie within specified ranges. For
example, I want to count the number of data points that
are < .50,the number of data points that are > or equal
to .50 AND <1.00, and the number of data points that are >
or equal to 1.00.

Any help would be greatly appreciated. Thanks.

Jason

 

[Don Guillett]

use countif for one condition =countif(myrng,1)
use sumproduct for more
=sumproduct((rngA>=.5)*(rngA<1))