MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

==========