It works


--
Regards,

Peo Sjoblom


"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:740ac2ceb1bfb@uwe...
Sorry i have a spread sheet that includes everyones age and i need to
count
all ages into specific age groups i.e all those between the ages of
21-30,31-
40 etc. The issue is the formula works well except it does not include
the
ages 21 and 30. So i do not know to what is miising within the formula
attached.

bj wrote:
What do you mean by "missing the age range"?
Please give an example

Hi

[quoted text clipped - 4 lines]

=SUM(COUNTIF(F26:F47,{"<=21","<30"})*{-1,1})

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1