How to check across columns for value appearing certain number of times?

Question

What is the best way to check if a value appears more than a certain number of times across multiple columns?

I have this in the column: =COUNTIF(A2:D2,"Adv")>1, will this work to check if the value occurs more than once across columns A-D?

https://docs.google.com/spreadsheets/d/1FYY00QTGaz0bituGKOjqqlI1MyHcOr8NlcPiEHlMDg8/edit?usp=sharing

Answer 1

try:

=(COUNTIF(K1:L1, "Adv")>0)*(M1="Adv")*(O1>=20)*(P1>=9)=1