1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

Help With Excel Spreadsheets

Discussion in 'Technology' started by AFButters, May 20, 2010.

  1. May 20, 2010 at 7:16 AM
    #1
    AFButters

    AFButters [OP] Rigger, Please!!

    Joined:
    Sep 10, 2008
    Member:
    #9113
    Messages:
    9,482
    Gender:
    Male
    First Name:
    "Butters"
    Albuquerque, NM
    Vehicle:
    2008 335xi BMW
    I am trying to make a single Excel file that has multi tabs for each game of our softball season

    I want one tab at the beginning to keep the running total for the stats of all games.

    Is there a way to get that tab to keep running totals for me for each player in each of the chosen stat catagories.
     
  2. May 20, 2010 at 7:21 AM
    #2
    AFButters

    AFButters [OP] Rigger, Please!!

    Joined:
    Sep 10, 2008
    Member:
    #9113
    Messages:
    9,482
    Gender:
    Male
    First Name:
    "Butters"
    Albuquerque, NM
    Vehicle:
    2008 335xi BMW
    NVM i figured it out
     
  3. May 20, 2010 at 7:22 AM
    #3
    sthrnprd116

    sthrnprd116 Well-Known Member

    Joined:
    Apr 21, 2010
    Member:
    #35726
    Messages:
    163
    Gender:
    Male
    First Name:
    Jordan
    North Carolina
    Vehicle:
    2010 DC Short Bed TRD Sport 4x4 Pyrite Mica
    N-Fab Step Bars, WeatherTech Liners, Bed Mat, Extang Trifecta Tonneau Cover
    Yes, you can reference different tabs within a "workbook" in a formula. Just create the formula on the main tab while selecting the cells on the other tabs.

    Edit: NVM you figured it out.:p
     
  4. May 20, 2010 at 7:48 AM
    #4
    Doc.SS

    Doc.SS ︻╦╤─

    Joined:
    Oct 6, 2009
    Member:
    #23899
    Messages:
    4,389
    Gender:
    Male
    First Name:
    Frank
    O'side
    Vehicle:
    T4R SR5
  5. May 20, 2010 at 9:41 AM
    #5
    AFButters

    AFButters [OP] Rigger, Please!!

    Joined:
    Sep 10, 2008
    Member:
    #9113
    Messages:
    9,482
    Gender:
    Male
    First Name:
    "Butters"
    Albuquerque, NM
    Vehicle:
    2008 335xi BMW
    =Sum( click on the box 1 [insert ","] box 2 etc..) through each work box then click and drag and it auto populates the code to the rest of the boxes.
     

Products Discussed in

To Top