Formulas
 

I need to a formula to calculate how many children from ages 3-12 i have in a
colum?

Formulas
 

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?

Formulas
 

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?

Formulas
 

=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.
--
David Biddulph

"Jessica" wrote in message
...
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?

Formulas
 

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?

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?