View Single Post
  #1   Report Post  
Hardy
 
Posts: n/a
Default COUNTIF and range?

I would like to count how many values there are between a certain range.

E.g.

In column B I have the age of individuals. I would like to count the number
of individuals that are between the age of 18 - 30
Can anyone help?

Also is there a simple formula for the calculation of age?