Results 1 to 5 of 5
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Sum in ExcelXP (ExcelXP)

    I need to add the numbers in about 10 cells and display the total in another cell. The 10 cells are not all in a row or column, but are scattered throughout the spreadsheet. I know I can create a formula, but is there a way I can control-click to select the 10 cells, and then tell Excel to put that total in the desired cell?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum in ExcelXP (ExcelXP)

    If you type =SUM( in the destination cell, you can select the cells to be summed by Ctrl-clicking them. Just press Enter or click the green check mark when you have selected the cells; Excel will add the closing bracket ).

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Sum in ExcelXP (ExcelXP)

    That did it! Thanks
    By the way, any recommendations for a book or online tutorial on Excel?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum in ExcelXP (ExcelXP)

    The books by John Walkenbach are highly regarded. Others will hopefully have more suggestions.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sum in ExcelXP (ExcelXP)

    Check out the links in <post#=348005>post 348005</post#>

    Steve

Posting Permissions

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