Announcement

Collapse
No announcement yet.

Excel spreadsheet question...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel spreadsheet question...

    Hoping you guys could tell me how to do this...

    http://img73.imageshack.us/my.php?im...adsheetqa6.jpg

    In the example above, I want to times each Tot. by 2. I don't want to have to go through every single cell one at a time to do so. Is there a way that I can take Column I and make it so that every cell in that column is automatically * by 2?

    For example, SP Zach Miller is a 30 Tot. so of course he would be a 60 after being * by 2... I want that... but for every cell. Is that possible without me having to go cell to cell and doing it manually?

    Same question... this time for rows.

    Yannick Caruso is listed as a 4/3/5... so add that up, and it'd be a 12. Is there a way to do that without doing it manually? Basically the same question as the columns... just flipped it to rows.

    Basically I have a very low understanding of Excel, and I'd love any help I can get.
    California Kodiaks - GM - 1982-2013
    Brewmaster's Cups: 1987
    Import League Champions: 1987, 1989
    Porter Division Champions:
    1986, 1987, 1989, 1999
    , 2000
    Import League Wild Card: 2001, 2003, 2004

  • #2
    You only have to do each forumula once and then drag it down.

    If you email me the spreadsheet, I'll put them in and send it back.
    The Great One!

    To many rings to count...

    Comment


    • #3
      Thanks... but I figured it out.

      The internet and tutorials are a wonderful thing!
      California Kodiaks - GM - 1982-2013
      Brewmaster's Cups: 1987
      Import League Champions: 1987, 1989
      Porter Division Champions:
      1986, 1987, 1989, 1999
      , 2000
      Import League Wild Card: 2001, 2003, 2004

      Comment

      Working...
      X