COUNTIF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to count criteria if the criteria is a 'range of numbers' and not 1 specific number?

In the example below, employees MUST retire at age 60, however, they have the OPTION to retire earlier.... any time between the age of 50 and 59. I have to count the number of employees that have the option of retiring each year...(e.g in 2004, 2005, 2006, etc). Therefore, as employees turn 50, they get added to the count and when they turn 60 they retire and are no longer counted.

I don't know what the formula is but I thought (for example) in 2004 where an employee is born in 1944 and they have the option of retiring any time between 1994 and 2003 that I would be able to make the following formula:
=COUNTIF(B1:B5,"1994,1995,1996,1997,1998,1999,2000,2001,2002,2003").

This formula isn't working. Thanks in advance to anyone who can help with this one. Cathy


A B C
Year reach Year reach
Age 50 Age 60
Birth Year (Option to Retire) (MUST Retire)

1944 1994 2004
1946 1996 2006
1946 1996 2006
1955 2005 2015
1956 2006 2016
1956 2006 2016
 
I used =DATEDIF(Birthday,TODAY(),"y") to get the age in years. (I used
Column C to return the age in years.) From that you can use
=IF(AND(C1>=50,C1<60),"May Retire",IF(C1>=60,"Must Retire",""))

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Cathy said:
Does anyone know how to count criteria if the criteria is a 'range of
Click to expand...
numbers' and not 1 specific number?
In the example below, employees MUST retire at age 60, however, they have
Click to expand...
the OPTION to retire earlier.... any time between the age of 50 and 59. I
have to count the number of employees that have the option of retiring each
year...(e.g in 2004, 2005, 2006, etc). Therefore, as employees turn 50, they
get added to the count and when they turn 60 they retire and are no longer
counted.
I don't know what the formula is but I thought (for example) in 2004 where
Click to expand...
an employee is born in 1944 and they have the option of retiring any time
between 1994 and 2003 that I would be able to make the following formula:
 
Back
Top