Below is a proposed solution to the Challenge 71 – Determine the Rank
In E2, use following formula and drag down
=SUMPRODUCT(–($B$2:$B$6+$C$2:$C$6+$D$2:$D$6>SUM(B2:D2)))
+SUMPRODUCT(–($B$2:$B2+$C$2:$C2+$D$2:$D2=SUM(B2:D2)))
Below is a proposed solution to the Challenge 71 – Determine the Rank
In E2, use following formula and drag down
=SUMPRODUCT(–($B$2:$B$6+$C$2:$C$6+$D$2:$D$6>SUM(B2:D2)))
+SUMPRODUCT(–($B$2:$B2+$C$2:$C2+$D$2:$D2=SUM(B2:D2)))