Greater than Less than formula
 

I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need to
know the count of B6:B31 that are greater than 30 but less than 39. etc. How?

Greater than Less than formula
 

In B32 put =COUNTIF(B6:B31,"<100")-COUNTIF(B6:B31,"<=50")

In B33 put =COUNTIF(B6:B31,"<49")-COUNTIF(B6:B31,"<=40")

In B34 put =COUNTIF(B6:B31,"<39")-COUNTIF(B6:B31,"<=30")

Vaya con Dios,
Chuck, CABGx3



"Help with Check Mark!!" wrote:

I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need to
know the count of B6:B31 that are greater than 30 but less than 39. etc. How?

Greater than Less than formula
 

Try these:

=SUMPRODUCT(--($B$6:$B$31<100),--($B$6:$B$3150))
=SUMPRODUCT(--($B$6:$B$31<49),--($B$6:$B$3140))
=SUMPRODUCT(--($B$6:$B$31<39),--($B$6:$B$3130))

"Help with Check Mark!!" wrote:

I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need to
know the count of B6:B31 that are greater than 30 but less than 39. etc. How?

Greater than Less than formula
 

enter
10
20
30
40
50
100
in C6:C11
Select D6:D11, and ctrl/shift/enter:
=FREQUENCY(B6:B31,C6:C11)

"Help with Check Mark!!" wrote
in message ...
I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know
the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need
to
know the count of B6:B31 that are greater than 30 but less than 39. etc.
How?