xls guru help needed for football tracking

Discussion in 'OT Technology' started by TD23, Sep 7, 2006.

  1. TD23

    TD23 Bring it home!

    Joined:
    May 6, 2001
    Messages:
    258
    Likes Received:
    0
    Location:
    under your bed
    FOOTBALL POOL SPREADSHEET
    So I'm making a spreadsheet to track 8 guys picks for winners of each week.
    It's a pick'em (no spread involved) pool.
    If there are 16 games, each game is given a score/weight (1-16; no number can be used twice) and if you pick correctly, you get that amount of pts if you pick wrong you get a zero for that game (perfect week = 136 PTS)
    The spread sheet will consist of the following:
    A1 = Week1 games
    B1 = Week1 winners
    C1 = Player1 pick
    D1 = PTS wagered

    My question: Is there an equation that I can use to automatically add the number of PTS Won in column D2-17 (if player pick in C1 is same as winner in B1 then pts in D1 = amount wagered / if not then D1 = 0) to be calculated as a sum in D17. ????????????????

    Damn. I just read what I typed... I need another beer :noes:
     
  2. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Man this is confusing.

    To add the the numbers in D2-17 use:
    =sum(d2:d17)
    in the cell to display the total

    To have a D cell represent the logic you describe use:
    =if(c1=b1, cell_holding_points_wagered, 0)
    you have to have the point wagered stored somewhere in your spreadsheet then replace cell_holding_points_wagered with that cell address.

    For a listing of formulas, you can look under Insert | Formula, then select logical. For the if statement the prototype says:
    =if(logical_test, value_if_true, value_if_false)

    So my suggestion above would display the points wagered if they picked the winner, or 0 if they didn't.

    That's the best I can do with your original post which is very confusing.
     
  3. TD23

    TD23 Bring it home!

    Joined:
    May 6, 2001
    Messages:
    258
    Likes Received:
    0
    Location:
    under your bed
    Thanks a ton for your help!
    I think I almost got the spreadsheet down... I'll definately plug in your suggestions and see what happens.
     

Share This Page