I have a large excel document with multiple lines. I need to be able to roll the multi-line invoices into one. Currently I am identifying them and adding a line and summing, then deleting the multiple lines. Is there a formula? I have to review over 77000 line items. help
are the multiple lines that you want rolled up identified with a unique identifier (like an invoice number?)
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Depends on file/data structure. But I'd think Pivot Table is your best option if data is organized in flat table structure.
I'd recommend uploading sample file with enough data to demonstrate your issue (25~50 line of data is usually enough).
Yes, the invoice number
When I click for an attachment, it is not opening a browser?
The button isn't currently working. You'd need to click on "Go Advanced" found at bottom right of quick reply menu.
Then find "manage attachments" hyperlink and click on it. It will open new tab/window for managing attachments.
=sumif([invoice number column],[single invoice number],[whatever column you're summing])
i'd generally suggest copying the entire invoice number row, pasting into another sheet, remove duplicates (data tab > data tools section > remove duplicates) and then paste that formula next to your unique invoice # list where [single invoice number] is a reference to the unique invoice #'s. make sense?
I added attachment but so not see it? Can you see it? If so, would you be able to show me in the spreadsheet? the =sumif isn't working for me?
okay, i did it wrong it is there now.
Perhaps add headings to your columns so we know what is what? And sample output?
So sum should be based on Column C?
Here's Pivot Table version and SUMIF.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Re: How can I roll up multi line totals into one?
Thank you so much!! I tried to pivot the other night but I still saw duplicate invoices? Today follwed your example and it gave me what I wanted. Thank you so much!!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks