You can reduce two (or many) criteria to a single criterium:


In an un-used cell enter:
=F1 & H1 and copy down

Then the criterium would be BlondeFemale
--
Gary's Student


"Clash" wrote:


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