formula help
Posted by D Cecil on September 13, 2001 9:23 AM
I need to count the numbers in one column according to the following breakout:
Total of cells >.25 but <5.25
Total of cells >5.25 but <10.25
Total of cells >10
Thanks for any help!
Dave
Posted by Aladin Akyurek on September 13, 2001 9:41 AM
Dave,
=SUMPRODUCT((A1:A100>.25)*(A1:A100 < 5.25))
=SUMPRODUCT((A1:A100>5.25)*(A1:A100 < 10.25))
=COUNTIF(A1:A100,">10")
Aladin
==========
