MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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