Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Total invoice amounts by project

    I have an Excel sheet showing all invoices for a time period along with which project each one is for. Some projects have multiple invoices, and I would like to total them, so I have just the total cost for each project. I know I should know how to do this, but my brain is refusing to cooperate.

    Thanks,

    LinD

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Lin,

    You have 2 choices I can think of:
    1. SumIf()
    2. Pivot Table.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Other choices:
    SUMIFS() if multiple criteria and using XL2007 or higher
    SumProduct()
    Various array formulations depending on needs...
    Steve

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I've attached a file. The column called ISBN identifies the projects. What I need to end up with is a list of the unique ISBNs and a total cost for each.
    Attached Files Attached Files

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Lin,

    Here's a sample of the Pivot Table approach.
    Note for this to work you'll have to format all the ISBN numbers properly as the ones w/o dashes are treated as numbers and show up in the pivot table as scientific notation. I've deleted all those rows for example purposes and also hidden some of the pivot table rows to focus on the example value I've chosen.
    Raw Data:
    Pivot1.JPG
    Pivot Table:
    Pivot2.JPG

    My sample file: Lin-sample invoice list.xlsx

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. The Following User Says Thank You to RetiredGeek For This Useful Post:

    lind (2013-10-22)

  7. #6
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks! I'll look it over tonight and learn a lot.

    Lin

  8. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In addition to the ISBN list and summation from the pivot table, you could get subtotals by month and/or year with the pivot table as well, and even break out by vendor name either in a table or as a report filter

    Steve

Posting Permissions

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