SUM PRODUCT: Ranking a Cell based on Criteria

Can someone help me figure out why my sumproduct formula isn't computing correctly?

I'm ranking some baseball pitchers based on a running total in Column AD, if two players have the same total in column AD the formula uses column BA as a tiebreaker. I have an overall rank for all pitchers, both AL (American League) and NL (National League). I want to break this ranking into a separate ranking in column G for AL only pitchers and column H for NL only pitchers

Where I'm running into trouble is the numbers aren't adding up correctly, cell H10 should read as a 1 because the Top ranked pitcher from column F pitches in the NL which would automatically make his NL rank 1 instead of 2 as it currently shows. The 2nd pitcher in column H11 should be a 2 instead of a 3 and so on.

In addition, the pitcher in cell G14 should also rank as a 1 because he is the top ranked AL pitcher from column E.

I've attached a my worksheet. Thanks!

Originally Posted by nflsales

G10=IF($E10=G$8,SUMPRODUCT(($E$10:$E$217=G$8)*(($AD$10:$AD$217+$BA$10:$BA$217/10^4)>=($AD10+$BA10/10^4))),"")
TRY THIS IN Cell G10 and copy across

This didn't work, I want it to look up the NL or AL from column E. Each pitcher has the league their from in column E.

Originally Posted by nflsales

see the attached file

Thanks very much this worked great!