+ Reply to Thread
Results 1 to 3 of 3

Total values in MOD grouped items

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Total values in MOD grouped items

    I have a shipping report that the company I develop systems for uses daily.

    Ive used a mod formula in Column N to detect duplicates in Column C:

    Please Login or Register  to view this content.
    And have used a similar formula in Column O to label each item as part of an "order number":

    Please Login or Register  to view this content.
    This has successfully separated these rows into groups that will be shipping together, based on similar names and has allowed me to use conditional formatting to identify the separate combo orders for the day.

    The data that we get from the company we distribute for is always uniform, it includes the amount paid for each item (column K, labeled PAID) as well as the total amount paid including shipping (column L, labeled Order Total.

    Unfortunately I need the total without shipping, which would be all of the PAID values that would be shipped together.

    Currently I'm using a macro that totals the current selection and then writes the total value in the next open cell to the right of the selected cell:

    Please Login or Register  to view this content.
    In the end I would like to have a VBA macro that would produce a TOTAL PAID column (based on the sum of the individual PAID values of an order) so I wouldn't have to do it by hand, the solution is really just failing me right now though

    An example spreadsheet is attached.

    Thanks

    PS: Its my first post, so please forgive me if i missed on some semantics
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Total values in MOD grouped items

    It would have helped if you had provided a few examples of the expected output. Or defined have Selection was in terms of an example range.

    Please Login or Register  to view this content.
    This will output the total for each group on the last row of each group.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-01-2010
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Total values in MOD grouped items

    Thanks very much for the reply, sorry for the delay in getting back on here.

    2 things really quickly, I solved this in the interim with a formula (much less eloquently i might add...)

    Please Login or Register  to view this content.
    which results in an accurately added grouping, but leaves a lot of extra numbers that i have yet to think of a way to hide as part of of the grouping.

    secondly,

    Please Login or Register  to view this content.
    returns a syntax error for me. If i were more familiar with VBA (like i wish i were) it seems like the thoughful bit of the code is all in front of me and i should be able to debug it myself, but sadly im not a very accomplished programmer by any means...

    Thanks again so much for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1