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?
|