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