G
Guest
I need to a formula to calculate how many children from ages 3-12 i have in a
colum?
colum?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
What data is the column? Just Ages or Dates of Birth?
G
Guest
D
David Biddulph
=COUNTIF(A:A,">="&3)-COUNTIF(A:A,">"&12)
Adjust the > and >= as appropriate, depending on whether the range should
include or exclude those whose ages are equal to 3 or equal to 12.
Adjust the > and >= as appropriate, depending on whether the range should
include or exclude those whose ages are equal to 3 or equal to 12.
G
Guest
Assuming ages in column a, try:-
=COUNTIF(A1:A30,">=3")-COUNTIF(A1:A30,">12")
Mike
=COUNTIF(A1:A30,">=3")-COUNTIF(A1:A30,">12")
Mike
G
Guest
Try to Filter the data on the age
Use Customs > Greater than 3 and less than 12
You will be able to view all details of children under this category
If you want to know how many then Mike's CountIF formula stands good
Use Customs > Greater than 3 and less than 12
You will be able to view all details of children under this category
If you want to know how many then Mike's CountIF formula stands good