I'm sure that this is very easy but I don't know where to start.
Column A: List of document numbers
Column B: List of amounts
A B
111 $5.00
222 $10.00
111 $5.00
222 $15.00
I need to merge all equal document numbers so that it shows the full amount on that document number. It needs look like this in the end:
A B
111 $10.00
222 $25.00
I realize a pivot table will do this but the formatting of a pivot table will not work with what I am ultimately trying to do.
Last edited by erisaaka; 02-22-2013 at 05:23 PM.
Pivot tables are best, howver you may use SUMIF on these lines
=SUMIF(A:A,111,B:B)
Life's a spreadsheet, Excel!
Say thanks, Click *
Hmmmm...Yes, I see how that works. I unfortunately have a lot of document numbers. I can't possibly go through and type each one in.
Which is why pivot tables exist..
www.cpearson.com/excel/pivots.htm
You can always format the cells to do away with borders as well as not display grand totals for rows and columns. Have a play!
A pivot table does this to my data:
111
$10.00
222
$25.00
I need it to do this:
111 $10.00
222 $25.00
Put the document number in the row label and the amount in values field...see attached
Okay, I can see why you would be confused as to why I am confused. I was trying to illustrate it simply. I have more than two columns. I need it all to be in one line.
Got it! I used your formula but changed it too: SUMIF(A:A,A1,B:B) I dragged down from there.
Thank you for helping me brainstorm this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks