I find using the sumproduct worksheet function is ideal for this type of
request.
=sumproduct(($a$1:$a$100="blonde")*($b$1:$b$100="f emale")*1)

the *1 at the end might not be needed


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=507192