Forum Discussion
COUNTIFS formula question
I have over 90 lines that I used a COUNTIFS formula, with 3 criteria, to identify specific companies. Is there a way for me to EASILY find the two companies, out of 90, that meet that criteria?
Hi Matt,
Depends how you would like to identify these companies. You may use Conditional formatting with formula in rule
=($P4<1)*($I4>4)*($L4<2)
apply it to $c4:$c10 and fill matched cell by green.
See attached