Thread: Formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?