Thread
:
count on condition / Formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
Posts: n/a
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.
Reply With Quote