Missing count of age to a group of ages

  • Thread starter chedd via OfficeKB.com
  • Start date
C

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

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
 
C

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
[quoted text clipped - 4 lines]
=SUM(COUNTIF(F26:F47,{"<=21","<30"})*{-1,1})
 
P

Peo Sjoblom

It works


--
Regards,

Peo Sjoblom


chedd via OfficeKB.com said:
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
[quoted text clipped - 4 lines]
=SUM(COUNTIF(F26:F47,{"<=21","<30"})*{-1,1})
 
B

bj

=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 said:
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
[quoted text clipped - 4 lines]
=SUM(COUNTIF(F26:F47,{"<=21","<30"})*{-1,1})
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top