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

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

Thanks Shane! That is a great start and think I can work with that. I guess
I should have mentioned that my columns are K for the Age and L for the
gender. Another important note is that I am pulling data from another
Worksheet named Members. I will have to figure out where to insert the
Members! into the formula and replace the A and B columns in your example
with K and L. Thanks so much! This is a great start!

Shane,

Your formula works perfectly! I was able to point to the Worksheet that
contained the data and reconfigure the formula for the columns that held the
data. It works GREAT! Thank you so much for your help, I sincerely
appreciate it!

Brenda

You can use DCount/DCountA if you want to do a count with more than 1 criteria.

Fire up the Excel help file and type DCount in the search box.
Click on DCount and there is a detail example you can follow.

Hope this help.