I need some help sorting a list... i have tried a pivot table but have not gotten it to work...
There are order numbers, and revenue amounts... i want to find a total revenue amount for the order number... so the list may look like...
ORDER # | REVENUE
1000 | $25
1001 | $55
1002 | $34
1002 | $54
1002 | $23
1003 | $76
and so on... one order number may have 1 line or may have 10 lines...
Any suggestions?
Create a single list of order numbers and use sumif.
Guess I'm not sure when I reread your post do you want it sorted or summed?
Last edited by Sam Capricci; 11-25-2015 at 11:15 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sorry, should have been more specific... i would like to sum the value of each order number... so the above example would become...
1000 = $25
1001 = $55
1002 = $111
1003 = $76
Does that make more sense? How does sumif work? what would the criteria be?
With a pivottable
say your order # list is in column A and your revenue is in column B. You can make a copy of your order numbers by highlighting column A and paste it to an empty column for instance column C. Then highlight the column and using the built in remove duplicates function remove the duplicates from that list.
Then using sumif =SUMIF(A:A,C2,B:B) you will get the totals for the order numbers. Sumif is (look at this column range,look for this item in that range, sum these values that appear across from that item in this column range)
Hope that helps.
Last edited by Sam Capricci; 11-25-2015 at 11:36 AM. Reason: Clarity
Very good Sambo, let me try that...
Thank you that worked... i can remember how to mark solved...
Post #4 missed?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks