Search by category

Search by category

Didn't find your answer?

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.

avatar
By RichardSchollar
14th Aug 2008 20:33

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

Thanks (0)
avatar
By neileg
15th Aug 2008 10:51

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.

Thanks (0)