Enter the gender you're looking up in B1 (Male, Female),
And the answer (Yes, No) in H1,

And try this formula:


=SUMPRODUCT((A2:A100=B1)*(G2:G100=H1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"DTomSimpson" wrote in message
...
I want to be able to check those identified as Male in Column A who voted
YES
in Column G. COUNTIF appears to work to check count of males or who voted
YES but I can't seem to figure out how to find out how many MALES voted YES.

I'm new to this, so I'm confident this is something easy that I just haven't
found yet.
Your help is appreciated.