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?