+ Reply to Thread
Results 1 to 4 of 4

Combine rows and total three colums

  1. 11-28-2012, 10:27 PM #1
    AlphaCraig
    AlphaCraig is offline
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Combine rows and total three colums

    I have a large amount of invoicing data (10000 rows) that I would like to summarise.
    I would like to sort by 'Inv No" Column "A" keeping the data in the first 7 columns and total the data in the last 3 columns
    I have attached sample data and a sample expected outcome.
    I was hoping for some code that I could run to do this as I will have an ongoing need for it.
    Your assistance is much apreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-28-2012, 10:57 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Combine rows and total three colums

    Here is one way...

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 11-28-2012 at 11:02 PM.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 11-28-2012, 11:57 PM #3
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Combine rows and total three colums

    Here's another option

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  4. 11-29-2012, 12:10 AM #4
    AlphaCraig
    AlphaCraig is offline
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Re: Combine rows and total three colums

    Thank you both for all your help.
    This will be a big time saver for me.

    Regards

    Craig
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1