Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Sum After Segmented Number Series in Column

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Paducah, KY
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    I hope someone can help me or point me in the right direction. I have a file that has three blank rows between each different storeroom number. I need to add totals to the second (middle) blank cell after every segmented number series under QTY, PRICE, and TOTAL; however, I need to have the flexibility to be able to pick a starting cell in any column, not just column B, C, and D (this is just one file we would use this for).

    STORE
    ROOM.....QTY......PRICE......TOTAL
    005-29........1........33.00......33.00

    Need total>...1........33.00.....33.00

    005-2921......1........73.64.....73.64
    005-2921......1........73.64.....73.64
    005-2921......1........73.64.....73.64

    Need total>...3.......220.92....220.92

    020-1065......2.........4.06......8.12
    020-1065......6.........4.06.....24.36

    Need total>...8.........8.06.....32.48

    Is there a macro that would do this? I've searched, but did not find one. I appreciate any assistance, thanks.

    [ This Message was edited by: Gary on 2002-02-22 09:56 ]

    [ This Message was edited by: Gary on 2002-02-22 09:59 ]

    [ This Message was edited by: Gary on 2002-02-22 10:01 ]

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi!

    You will want to post your question in the correct forum. This is where people can test their signatures and things like that. Click on the link:

    http://www.mrexcel.com/board/viewforum.php?forum=2&1830=

    and post your question there. Just copy/paste it. Then, I'll take a look and many others will too!

    Welcome to MrExcel!
    ~Anne Troy

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
  •