Hi,

Have the upper and lower limits in range A1:B5. In cell C1, enter the
following formula

=SUMPRODUCT((range=A1)*(range<=B1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...
Just wondered whether u can help me solve this:
Again I want to group a set of numbers as follows"

Eg: Group: 2,9,10,15,19,20,29,30,37,38,39,40,43

The groups I am seeking a
Numbers within 1-9 = answer above is 2
Numbers between 10 and 19 = answer is 3
Numbers 20 and 29 = answer is 2
Numbers between 30 and 39 = answer is 4
Numbers between 40 and 45 = answer is 2

Would like to know how to use countif function or any other function to
obtain the above answers.

Thanks
RodJ




--
RodJ


"Ashish Mathur" wrote:

=countif(range,"<22") and =countif(range,"22")

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...

eg: number group = 2,12,18,35,36,40. I need a function that will tell
me
how
many numbers are under 22 and how many are over 23.
Answer I am looking for is:
Under 22 = 3
Over 22 = 3.

Is there a function that can give me this answer. Thanks
--
RodJ