Thread: How do I perform operations within a funtion that operates on colu
View Single Post
  #1   Report Post  
crander8
 
Posts: n/a
Default How do I perform operations within a funtion that operates on colu
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


Reply With QuoteReply With Quote