Results 1 to 3 of 3

Thread: Excel Help

  1. #1
    Location
    Hamilton, ON
    Rep Power
    40

    Dobber Sports Supreme Grand Master

    Default Excel Help

    I'm trying to get a excel doc made up, and I know there should be a way to do what I want but I can't think of it.

    I'm doing a golf tourny with buddies and we're going to track our scores on a shared Excel doc. I want to make a master tab that will show everyones scores. Simple.

    However, I want to have it also show what hole everyone is on. I was thinking of something like "If the score of a player is filled out, then display this cell's value". So if a pair has finished hole 5, they put in their score, and the formula would pick up "oh hole 5 is filled out, they must be on hole 6". But I can't think of how to run that formula.

    Any help would be great.
    12 Team, H2H, Keep 6
    G, A, Pts, PPP, +/-, FW, PIMs
    W, Saves, S%, GAA
    2C, 2LW, 2RW, 4D, 2G, 5BN, 2IR, 1IR+, 1NA

    C: Eichel, Kuznetsov, Rossi
    LW: Connor, Meier (RW), Forsberg, E.Kane, Stutzle (C), Schenn (C)
    RW: Marner, Pastrnak
    D: Carlson, Theodore, Bouchard, Power, Chabot
    G: Hellebuyck, MAF, Gibson

  2. #2
    Location
    Hamilton, ON
    Rep Power
    40

    Dobber Sports Supreme Grand Master

    Default Re: Excel Help

    Nvm, I figured it out lol.

    If you care it's just a count function.

    =count(DATERANGE)+1.
    12 Team, H2H, Keep 6
    G, A, Pts, PPP, +/-, FW, PIMs
    W, Saves, S%, GAA
    2C, 2LW, 2RW, 4D, 2G, 5BN, 2IR, 1IR+, 1NA

    C: Eichel, Kuznetsov, Rossi
    LW: Connor, Meier (RW), Forsberg, E.Kane, Stutzle (C), Schenn (C)
    RW: Marner, Pastrnak
    D: Carlson, Theodore, Bouchard, Power, Chabot
    G: Hellebuyck, MAF, Gibson

  3. #3
    Invictus's Avatar
    Invictus is online now
    Join Date
    Sep 2015
    Posts
    3,452
    Location
    Canada
    Rep Power
    33

    Dobber Sports Expert

    Default Re: Excel Help

    I got to this too late... lol

    I prefer to use CountIF or CountIFS as Count is only for numeric (which works in your case) and IFS allows for multiple criteria which is needed sometimes.
    The Team **CHAMPIONS**
    LW(3)- C(3)- RW(3)- D(4)- G(2)- Bench(4)- IR-

    1 Year Point League 11 Teams *Two Year Champion Streak*
    Player- (G)-3 (A)-2 (+/-)-1 (PPP)-1 (SHP)-2 (GWG)-1 (FW)-0.02 (HITS)-0.1 (BLOCKS)-0.2 (SHOTS)-0.05
    Goalie- (W)-4 (GA)- -1 (SV)-0.1 (SHO)-3


Posting Permissions

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