Missing count of age to a group of ages

[chedd via OfficeKB.com]

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})

 

[Guest]

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

 

[Peo Sjoblom]

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

 

[chedd via OfficeKB.com]

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.

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})

 

[Peo Sjoblom]

It works


--
Regards,

Peo Sjoblom

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.

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})

 

[Guest]

=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

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.

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})