Greater than Less than formula

[Guest]

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?

 

[Guest]

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

 

[Guest]

Try these:

=SUMPRODUCT(--($B$6:$B$31<100),--($B$6:$B$31>50))
=SUMPRODUCT(--($B$6:$B$31<49),--($B$6:$B$31>40))
=SUMPRODUCT(--($B$6:$B$31<39),--($B$6:$B$31>30))

 

[Bob Umlas]

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

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?