count on condition / Formula

G

Guest

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.
 
B

Bob Phillips

-- 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)
 

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

How to combine SUMPRODUCT with COUNTIF? 7
Count if formula error 5
how do i count how many times x in column a = 1 or 2 in column b 8
Tricky Conditional Count 5
Counting blank unique entries 5
formula with variable parameter 1
Sum total using Sumproduct if two criteria met 5
countif question 3

Top