I have various spreadsheets where i have the same product code but muliple values. For each individual spreadsheet, I would like to know Is there a way of adding the values together so it ends up with just the one product code with the total of the sum of the values, or even an extra line with the code and total without me using the sum function manually for each product code?
Last edited by WasWodge; 08-03-2010 at 03:22 PM.
pivot table?
again no crystal ball here!
need to see your data
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
hopefully the attachment will make things a bit clearer. IN COLUMN "H" labelled Prodcode you see there are multiple entries of the product code, then in column "K" labelled "Qty Pkd" you will see there are different values with each product code. I want to get a total of the "Qty Pkd" values alongside the appropiate prodcode.
2(1).xlsx
see attached
Cheers Martin, now Ican see how pivot tables can be used it's time to read up some more and practice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks