formula help please

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I am trying to count the number of cells within a list
whose value falls between certain numbers can you please
provide me with a formula to do this that can be
automatically adopted for other value sets as well (I have
been using one but have to manually change it each time I
change the value variation). For example, those that fall
under 10, then those that fall between 10 and 15 etc as I
have to go by 5's up to 100+ and am finding it tedious.
 
Hi
if column A stores the values , B1 the lower boundary and C1 the upper
boundary try
=SUMPRODUCT(--(A1:A1000>=B1),--(A1:A1000<C1))
 
Jay

Assume your numbers to count are in column A

In column B enter 5 through 150 in increments of 5.

In C1 enter =COUNTIF($A$1:$A$500,"<="&B2)-COUNTIF($A$1:$A$500,"<="&B1)

Drag/copy down column C

Gord Dibben Excel MVP
 
Back
Top