View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Try this:

=SUMPRODUCT(--(A1:A100="Male"),--(G1:G100="Yes"))

Or, use cells to hold the criteria:

H1 = Male
I1 = Yes

=SUMPRODUCT(--(A1:A100=H1),--(G1:G100=I1))

Biff

-----Original 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.
.