Excel rows count using counting formula involving multiple columns

Question

I'm struggling to take a count of rows in excel sheet (using formula) involving 3 columns of data say a, b & c. The condition is having value 111 in column a besides column b or column c having a 100. So, it is like

a2:a500="111" AND (b2:b500=100 OR c2:c500=100) 

Answer 1

How about:

=COUNTIFS(A2:A500, "111", B2:B500, "100") + COUNTIFS(A2:A500, "111", C2:C500, "100", B2:B500, "<>100")

Answer 2

You can use SUMPRODUCT:

=SUMPRODUCT((a2:a500=111)*((b2:b500=100)+ (c2:c500=100)>0))