Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Paste Special -> SUM (Excel 97)

    Hello Everyone...

    Is it possible to copy a group of cells and then paste the cells sum? I have a lot of summing to do on a spreadsheet which is very inconsistent. I also have to highlight the cells that are in the sum on each row, and since I have to select the cells anyway I thought it would be a timesaver to be able to paste the sum...

    Possible or am I dreaming?

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Special -> SUM (Excel 97)

    If you select an empty cell and click on the SUM tool bar icon, then select the cells, when you press enter you will get the sum of those cells.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Paste Special -> SUM (Excel 97)

    Well, yes I know that ..... I kind of want to go backwards in the process. I want to copy the cells and then paste the sum.

    It may not make sense why I would want to do this, and I'd love to show my spreadsheet, but I can't because it is sales information.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Special -> SUM (Excel 97)

    Do you want to paste a formula that will sum the selection, or do you want to paste the sum as a value? Where do you want to paste it?

    You might be able to use a macro like the one below which will put a formula that will sum the current selection into cell A1 of the active sheet.

    <pre>Public Sub PasteSum()
    ActiveSheet.Range("A1").Formula = "=SUM(" & Selection.Address & ")"
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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