CountIf Statements

[jwcharlie16]

Is there a way to make a CountIf statement count based on 2 criteria instead
of 1? For example, let's say I want to count everything in a 2 column range
if it finds yes in one column and Red in the other column. I was thinking
maybe I might need to combine two different types of If statements, but not
sure how that would work. Can you help me, please?

 

[RagDyer]

Try this:

=SUMPRODUCT((A1:A100="Yes")*(B1:B100="Red"))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Is there a way to make a CountIf statement count based on 2 criteria instead
of 1? For example, let's say I want to count everything in a 2 column range
if it finds yes in one column and Red in the other column. I was thinking
maybe I might need to combine two different types of If statements, but not
sure how that would work. Can you help me, please?

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$2:$A$100=2),--($B$2:$B$100="Red"))

which effects a multiconditional counting.