software

Hi all,

can you give a countif formula more than one condition/criteria, e.g.
=countif(P:P,quot;femalequot;) and say for instance Blonde, how would I include
the second criteria.

I tried a number of ways =countif(P:P,quot;femalequot;;quot;blondequot;) ,
=countif(P:P,quot;femalequot;) countif(P:P,quot;blondequot;) but nothing works.

Cheers--
Clash
------------------------------------------------------------------------
Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=507155=SUMPRODUCT(--(P2:P200={quot;femalequot;,quot;blondequot;}))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range..--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Clashquot; gt; wrote in message
...
gt;
gt; Hi all,
gt;
gt; can you give a countif formula more than one condition/criteria, e.g.
gt; =countif(P:P,quot;femalequot;) and say for instance Blonde, how would I include
gt; the second criteria.
gt;
gt; I tried a number of ways =countif(P:P,quot;femalequot;;quot;blondequot;) ,
gt; =countif(P:P,quot;femalequot;) countif(P:P,quot;blondequot;) but nothing works.
gt;
gt; Cheers
gt;
gt;
gt; --
gt; Clash
gt; ------------------------------------------------------------------------
gt; Clash's Profile:
www.excelforum.com/member.php...oamp;userid=18951
gt; View this thread: www.excelforum.com/showthread...hreadid=507155
gt;

One of those you quoted should work

=countif(P:P,quot;femalequot;) countif(P:P,quot;blondequot;)

or alternatively

=sum(countif(P:P,{quot;femalequot;,quot;blondequot;}))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=507155
many thanks boths--
Clash
------------------------------------------------------------------------
Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=507155