Formula count range cells with 2 criteria
Posted by Nicole on February 04, 2002 4:04 PM
I have a list of names which is also divided in gender and groups (1 - 3). I want to count every male and female separate, but also divided into the three groups.
At this moment I have: =COUNTIF(D2:D21="male",COUNTIF(G2:G21="1")). Probably I am doing something simple wrong, but I haven't got a clue what it is.
Can somebody help me out?
Thanx!
Nicole
Posted by Aladin Akyurek on February 04, 2002 4:10 PM
=SUMPRODUCT((D2:D21="male")*(G2:G21=1))
where group value is assumed to be a number.
==================
Posted by Nicole on February 04, 2002 8:11 PM
Nicole
