Formulas
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
"Mike H" wrote:
Assuming ages in column a, try:-
=COUNTIF(A1:A30,"=3")-COUNTIF(A1:A30,"12")
Mike
"Jessica" wrote:
Just ages
"Toppers" wrote:
What data is the column? Just Ages or Dates of Birth?
"Jessica" wrote:
I need to a formula to calculate how many children from ages 3-12 i have in a
colum?
|