formula

Posted by Jackie on January 06, 2002 12:23 AM

I need to write a formula that checks a condition in 2 different columns e.g

Gender age

Female 24
Female 24
Female 13
Male 24
Male 13

I need a formula that counts how many females have the age of 24 and displays the answer anywhere.

Thanks in advance.
Jackie

Posted by Aladin Akyurek on January 06, 2002 3:20 AM

Jackie --

=SUMPRODUCT((A2:A25="Female")*(B2:B25=24))

where A2:A25 houses the gender and B2:B25 the age.

Aladin

========