I thought that might be the case, and thought about including it, but you
seemed so definite <G

=SUMPRODUCY(--(F2:F200="blonde"),--(H2:H200="blonde"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Clash" wrote in message
...

Hi all,

I know that I have asked this question before, but I got it a bit
wrong.

What I am trying to count is criteria from two different columns, lets
say column F and column H.

i.e. F, I will count all of the females and H I will count all of the
Blondes. But what I am trying to count is all of the Blonde Females,
therefore using being able to seperate them from the Brunette Females,
Redhead Females, etc.

cheers

Clash


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