software

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: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=507192I thought that might be the case, and thought about including it, but you
seemed so definite lt;Ggt;

=SUMPRODUCY(--(F2:F200=quot;blondequot;),--(H2:H200=quot;blondequot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Clashquot; gt; wrote in message
...
gt;
gt; Hi all,
gt;
gt; I know that I have asked this question before, but I got it a bit
gt; wrong.
gt;
gt; What I am trying to count is criteria from two different columns, lets
gt; say column F and column H.
gt;
gt; i.e. F, I will count all of the females and H I will count all of the
gt; Blondes. But what I am trying to count is all of the Blonde Females,
gt; therefore using being able to seperate them from the Brunette Females,
gt; Redhead Females, etc.
gt;
gt; cheers
gt;
gt; Clash
gt;
gt;
gt; --
gt; Clash
gt; ------------------------------------------------------------------------
gt; Clash's Profile:
www.excelforum.com/member.php...oamp;userid=18951
gt; View this thread: www.excelforum.com/showthread...hreadid=507192
gt;

I find using the sumproduct worksheet function is ideal for this type of
request.
=sumproduct(($a$1:$a$100=quot;blondequot;)*($b$1:$b$100=quot;f emalequot;)*1)

the *1 at the end might not be needed--
bob777
------------------------------------------------------------------------
bob777's Profile: www.excelforum.com/member.php...oamp;userid=28504
View this thread: www.excelforum.com/showthread...hreadid=507192You can reduce two (or many) criteria to a single criterium:In an un-used cell enter:
=F1 amp; H1 and copy down

Then the criterium would be BlondeFemale
--
Gary's Studentquot;Clashquot; wrote:

gt;
gt; Hi all,
gt;
gt; I know that I have asked this question before, but I got it a bit
gt; wrong.
gt;
gt; What I am trying to count is criteria from two different columns, lets
gt; say column F and column H.
gt;
gt; i.e. F, I will count all of the females and H I will count all of the
gt; Blondes. But what I am trying to count is all of the Blonde Females,
gt; therefore using being able to seperate them from the Brunette Females,
gt; Redhead Females, etc.
gt;
gt; cheers
gt;
gt; Clash
gt;
gt;
gt; --
gt; Clash
gt; ------------------------------------------------------------------------
gt; Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
gt; View this thread: www.excelforum.com/showthread...hreadid=507192
gt;
gt;

That should be SUMPRODUCT of course.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Bob Phillipsquot; gt; wrote in message
...
gt; I thought that might be the case, and thought about including it, but you
gt; seemed so definite lt;Ggt;
gt;
gt; =SUMPRODUCY(--(F2:F200=quot;blondequot;),--(H2:H200=quot;blondequot;))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Clashquot; gt; wrote in
message
gt; ...
gt; gt;
gt; gt; Hi all,
gt; gt;
gt; gt; I know that I have asked this question before, but I got it a bit
gt; gt; wrong.
gt; gt;
gt; gt; What I am trying to count is criteria from two different columns, lets
gt; gt; say column F and column H.
gt; gt;
gt; gt; i.e. F, I will count all of the females and H I will count all of the
gt; gt; Blondes. But what I am trying to count is all of the Blonde Females,
gt; gt; therefore using being able to seperate them from the Brunette Females,
gt; gt; Redhead Females, etc.
gt; gt;
gt; gt; cheers
gt; gt;
gt; gt; Clash
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Clash
gt; gt; ------------------------------------------------------------------------
gt; gt; Clash's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18951
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=507192
gt; gt;
gt;
gt;
It is not, the * does all the coercion needed.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;bob777quot; gt; wrote in
message ...
gt;
gt; I find using the sumproduct worksheet function is ideal for this type of
gt; request.
gt; =sumproduct(($a$1:$a$100=quot;blondequot;)*($b$1:$b$100=quot;f emalequot;)*1)
gt;
gt; the *1 at the end might not be needed
gt;
gt;
gt; --
gt; bob777
gt; ------------------------------------------------------------------------
gt; bob777's Profile:
www.excelforum.com/member.php...oamp;userid=28504
gt; View this thread: www.excelforum.com/showthread...hreadid=507192
gt;

Thanks for all your help.

and just to let you know how I worked it out, I used this quot;array
formulaquot;.

=sum((F2:F200=quot;femalequot;)*(H2:H200=quot;blondequot;)) and then pressed
Ctl/Shift/enter.

and it worked.

Once again thanks for your help.--
Clash
------------------------------------------------------------------------
Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=507192