Hi,
Why is this formula giving me Value! as an error. I want to combine sumproduct to exhaust one of the countifs possibilities using + for OR operator.
=IF(SUM(A2:D2)=0,"",SUMPRODUCT(COUNTIFS(A:A,A2,B:B,B2,C:C,C2,D:D,D2)>1)+
COUNTIFS(A:A,A2,B:B,B2,C:C,C2)>1)+COUNTIFS(A:A,A2,B:B,B2,D:D,D2)>1+COUNTIFS(A:A,A2,C:C,C2,D:D,D2)>1
Bookmarks