It is not, the * does all the coercion needed.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bob777" wrote in
message ...

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