Hello all!

Looking some help on a membership spreadsheet I am working on. I am a novice
Excel user and am stuck trying to make a calculation happen that I really
need!

I have a database with members and multiple ages. I want to group the ages
and by their gender. For instance I am looking for a formula that will give
me all the Female members between the ages of 21 and 25, 26 and 30 and so on.
I have a column created that has the age (for example the number 23) and a
column that has a gender ( for example the letter F or M). This also would
apply for Male members. I have successfully managed to break them down to
age ranges as a group but need to separate them out . I really could use
some direction and any help would greatly be appreciated!

Thanks!

Brenda