formula help please

[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.

 

[Frank Kabel]

Hi
if column A stores the values , B1 the lower boundary and C1 the upper
boundary try
=SUMPRODUCT(--(A1:A1000>=B1),--(A1:A1000<C1))

 

[Gord Dibben]

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