Jeanette
here's the first one:
=SUMPRODUCT(--(A1:A10=0),--(A1:A10<=9),--(B1:B10="male"))
Adjust as necessary
Regards
Trevor
"Jeanette" wrote in message
...
I believe this is a Vlookup, but could be mistaken, my problem is as
follows:
I am trying to identify the number of male vs. female in an age range,
houw
would I write this in a formula?
Age Gender
5 Female
35 Male
7 Male
15 Female
9 Female
Age ranges are 0 - 9, 10 - 19, 20 - 29, 30 - 39, etc.
|