conditions in "countif"

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

Clash

Hi all,

can you give a countif formula more than one condition/criteria, e.g.
=countif(P:P,"female") and say for instance Blonde, how would I includ
the second criteria.

I tried a number of ways =countif(P:P,"female";"blonde")
=countif(P:P,"female")+countif(P:P,"blonde") but nothing works.

Cheer
 
=SUMPRODUCT(--(P2:P200={"female","blonde"}))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range..


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
One of those you quoted should work

=countif(P:P,"female")+countif(P:P,"blonde")

or alternatively

=sum(countif(P:P,{"female","blonde"}))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF date formula 3
complex CountIf situation 3
Excel Need Countifs Formula Help 0
conditions in "countif" 6
COUNTIF question 4
A formula that only shows the number of ex: "A" in a column and 1
Using Countif two criteria 5
Setting multiple conditions to return a figure from multiple cells 4

Back
Top