Results 1 to 5 of 5

SUM PRODUCT: Ranking a Cell based on Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ranking cell based on adjacent cell criteria?
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2014, 06:14 AM
  2. [SOLVED] Ranking based on criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-17-2014, 04:22 AM
  3. Ranking Based on Three Criteria
    By annie82 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-28-2013, 01:21 AM
  4. Excel 2007 : Ranking Based on Three Criteria
    By CRIMEDOG in forum Excel General
    Replies: 4
    Last Post: 02-09-2012, 08:18 PM
  5. Ranking based on certain criteria?
    By Ahmad Adha Ali in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2005, 04:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1