How do I perform operations within a funtion that operates on colu

C

crander8

I am trying to calculate the % of people under a certain age. In the
COUNTIF() funtion, how do I calculate the age and then compare it to the
chosen value?
e.x. =COUNTIF(A1:A3,(calculate age) <=60)

7/14/1932
4/28/1951
11/11/1939
 
J

Jason Morin

COUNTIF has its limits. Here are 2 ways:

=SUMPRODUCT(--(YEAR(TODAY())-YEAR(A1:A3)<=60))
=SUMPRODUCT(--(DATEDIF(A1:A3,TODAY(),"y")<=60))

HTH
Jason
Atlanta, GA
 
C

crander

THANKS

Jason Morin said:
COUNTIF has its limits. Here are 2 ways:

=SUMPRODUCT(--(YEAR(TODAY())-YEAR(A1:A3)<=60))
=SUMPRODUCT(--(DATEDIF(A1:A3,TODAY(),"y")<=60))

HTH
Jason
Atlanta, GA
Click to expand...
 
Top