Hi

I am using this formula to count the number of ages to add to a group of ages.
It is fine until I have age of 21 or 30 to where it is missing the age range
in the count. Please can you help so i can pick these missing ages in my
report.

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

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

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

"chedd via OfficeKB.com" wrote:

Hi

I am using this formula to count the number of ages to add to a group of ages.
It is fine until I have age of 21 or 30 to where it is missing the age range
in the count. Please can you help so i can pick these missing ages in my
report.

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

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

If you want to include 21 and 30 you can use

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

if not then the original formula works as it should


--
Regards,

Peo Sjoblom



"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:7408f90b31bfb@uwe...
Hi

I am using this formula to count the number of ages to add to a group of
ages.
It is fine until I have age of 21 or 30 to where it is missing the age
range
in the count. Please can you help so i can pick these missing ages in my
report.

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

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

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

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

=SUM(COUNTIF(F26:F47,{"<21","<=30"})*{-1,1})
should work
if you want to include 21 and 30, you needed to change where the equal sign
went

"chedd via OfficeKB.com" wrote:

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