Untitled
unknown
plain_text
2 years ago
159 B
4
Indexable
=SUMPRODUCT((COUNTIFS($A$3:$A$3432, $A$3:$A$3432, $B$3:$B$3432, "yes", $C$3:$C$3432, "ITO")>0)*(COUNTIFS($A$3:$A$3432, $A$3:$A$3432, $B$3:$B$3432, "yes")>0))
Editor is loading...
=SUMPRODUCT((COUNTIFS($A$3:$A$3432, $A$3:$A$3432, $B$3:$B$3432, "yes", $C$3:$C$3432, "ITO")>0)*(COUNTIFS($A$3:$A$3432, $A$3:$A$3432, $B$3:$B$3432, "yes")>0))