Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Funding SUM of cells that are in the same row as another loo

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I an importing date from an AS400 system into Excel. I then need to find all of the values in column B that are the same, and add the values in column D that are in the same rows.
    I am having a difficult time finding a way to do this. Of course it doesn't help that I am fairly inexperienced with formulas, and VB functions.

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Perry

    If you Sort the data all the doubles will be together. You could then probably use the "Subtotal" feature found under Data.

    Or perhaps a simple pivot table?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the response, but it seems I left out an important piece of the puzzle. The method of accumulating this data needs to reside on a blank form. When I import the data from the AS400, I have no idea how many of each match I will retrieve. I only know which columns the data will appear in. I am trying to "automate" the compiling of the data I import daily. With many entries each day, theis is a very time consuming task to do manually.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perry, I don't see why that matters????



  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well Dave, this may just be a case of my ignorance, but I didn't think I could use the subtotals function without knowing exactly which cells I wanted the subtotals from???

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK Dave, I see what that does now. I don't have my file here at home, but I tried the function you suggested, and it may just do it. I was not familiar with the subtotal function and misunderstood what it did.
    Thanks for the tip. I will give it a try at work tomorrow.

  7. #7
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perry,

    What Dave is saying is sort the data on column B so they are grouped together, then use ths Data|Subtotal menu option to sub-total column D at each change in column B

    Richard

    I see you got the idea just as I was clarifying. All's well that ends well. Hope it's what you want.

    Richard

    [ This Message was edited by: RichardS on 2002-03-26 19:25 ]

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The subtotal function works great for grouping my totals, but the next problem is that I need to move that total to another page to chart it too. Is there a way to do this without knowing which cells my totals are in, or do I need to attack this from a different angle?
    Always a new twist the problem huh?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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