| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
THANKS
"Jason Morin" wrote: 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 -----Original Message----- 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 . |
Threaded Mode
