conditions in "countif"

  • Thread starter Thread starter Clash
  • Start date Start date
C

Clash

Hi all,

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

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

i.e. F, I will count all of the females and H I will count all of th
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:confused
 
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)
 
I find using the sumproduct worksheet function is ideal for this type of
request.
=sumproduct(($a$1:$a$100="blonde")*($b$1:$b$100="female")*1)

the *1 at the end might not be needed
 
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
 
That should be SUMPRODUCT of course.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Bob Phillips said:
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)
Click to expand...
 
It is not, the * does all the coercion needed.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks for all your help.

and just to let you know how I worked it out, I used this "array
formula".

=sum((F2:F200="female")*(H2:H200="blonde")) and then pressed
Ctl/Shift/enter.

and it worked.

Once again thanks for your help.:)
 
Back
Top