count on condition / Formula
 

Q1: I want to count how many of many data is under "panel" and in in "yellow"
colour. when I use =COUNTIF(A1:B6,"panel") it works and
=COUNTIF(B2:B7,"yellow")) it also works but how to combine this two?

Q2: some answer I saw posted
=SUMPRODUCT(--(A1:A100="example"),--(B1:B100=2)). what is the "--" to be
replaced with?


appreciate your answer. thanks in advance.

count on condition / Formula
 

-- shouldn't be replaced with anything.

Is your first range really A1:B6 or A1:A6, if the latter then just use

=SUMPRODUCT(--(A1:A6="panel"),--(B2:B7="yellow"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SAM ONG" <SAM wrote in message
...
Q1: I want to count how many of many data is under "panel" and in in
"yellow"
colour. when I use =COUNTIF(A1:B6,"panel") it works and
=COUNTIF(B2:B7,"yellow")) it also works but how to combine this two?

Q2: some answer I saw posted
=SUMPRODUCT(--(A1:A100="example"),--(B1:B100=2)). what is the "--" to be
replaced with?


appreciate your answer. thanks in advance.