Hi,

Assume your range of data is A1:B11 with A1 containing the title Age and
column B containing Gender. The formula for females between 21 and 25 is
shown below, just modify this for the other conditions,


=SUMPRODUCT(--($A$2:$A$11=21),--($A$2:$A$11<=25),--($B$2:$B$11="F"))

--
Thanks,
Shane Devenshire


"NoviceUser2008" wrote:

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