Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Copy Data With Associated Name (2003)

    See attached. I would like to have a formula to be inserted at the highlighted cells that would sum the values in column D that are only associated with the respective point name. Any ideas?
    Thanks in advance.
    Jeff
    Attached Files Attached Files

  2. #2
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Re: Copy Data With Associated Name (2003)

    Jeff:

    I would do this without using Excel VBA. But my way takes three steps to set up.
    My attachment is your attachment, marked up. For sake of an example, I made up values in Col. E for each row of data, rows 2:21.

    Step 1: Fill in empty cells in Col. B
    Select all the cells in Col. B in the used range -- B2:B21, in your case.
    Key: F5, then Alt-s, then k. (this action will select all empty cells in Col. B .) Make sure that the active cell in the selected range is cell B3, the one just under B2.
    Key: equals, up-arrow, Ctrl-Enter. Now every cell in Col. B. has an entry.

    Step 2: Create a SUMIF formula in Col. D, cell D4
    In D4, enter the formula: =sumif($B:$B,B$4,$E:$E)

    Step 3: Copy/paste the SUMIF formula
    Copy that formula into your cells D10, D12, D16, and D21.

    Does that work for you?
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copy Data With Associated Name (2003)

    John,
    That looks great. One little twist, assume each point has meters that both receive (positive) and deliver (negative). How would I sum all of the positive meters for a particular point, and all of the negative ones?
    Thanks again.

Posting Permissions

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