Hi all,

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

I tried a number of ways =countif(P:P,"female";"blonde") ,
=countif(P:P,"female")+countif(P:P,"blonde") but nothing works.

Cheers


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=507155