I'm hoping some of the Excel gurus out there might be able to help me. I have a list
of peoples ages and I need to write a formula to only include people over the age of sixty. Do I use an if statement or is there a more clever and easy way of writing a formula? All help appreciated.
Damian Flynn
Replies (2)
Please login or register to join the discussion.
What end result are you aiming for?
Hi Damian
It really depends on what you want to end up with eg do you want a count of people over 60 in which case possibly COUNTIF will suffice:
=COUNTIF(A:A,">60")
assuming the ages are in column A.
If this doesn't provide a workable solution for you, please expand on what you are trying to achieve.
Best regards
Richard
Use a filter
Easiest way is to apply an autofilter on the age column and in the Custom box for the filter add 'is greater than' 60.