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