OK....I have a table of data with names unique numbers in the first column although these numbers can be replicated in the data as it relates to people ordering things...in the end column is the numerical total of the order.
I would like excel to create a separate table where by it searches the first column and makes it so there are no duplications and adds up the total cost of their order so they are not charged in 2 transaction.
Quite confusing to write down  |
Reply privately, Reply in forum +quote
or View forums list | |
 |
By *av1970Man
over a year ago
Tattershall |
Sounds like you need to create a pivot table, the table can then show the unique reference and the sum total of all order values against that reference ...are you using 2010 as it is a lot easier to do. |
Reply privately, Reply in forum +quote
or View forums list | |
"Sounds like you need to create a pivot table, the table can then show the unique reference and the sum total of all order values against that reference ...are you using 2010 as it is a lot easier to do."
unfortunately not, 2003
I tried a pivot table but it wouldn't add up the cost of the orders,just returned the count of data. |
Reply privately, Reply in forum +quote
or View forums list | |
"Have you tried to SUM the values in the column?"
it's not the sum of all the orders I need. I need a list of each order where multiple orders are added together.
So if.....
1 - 5
2 - 7
3 - 2
4 - 6
5 - 3
1 - 3
3 - 4
6 - 8
I'd want a formula that would give me
1 - 8
2 - 7
3 - 6
4 - 6
5 - 3
6 - 8
Does that make sense? |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
Pivot table. Double click in the pivot table once you've produced it (if it's still returning a count) and there will be an option to change the result to sum. |
Reply privately, Reply in forum +quote
or View forums list | |
|
By *av1970Man
over a year ago
Tattershall |
Just did a quick try with a pivot in an old version of excel i still have...and as above you should be able to highlight the cells that are giving a count, right click and change the field settings to sum. |
Reply privately, Reply in forum +quote
or View forums list | |
» Add a new message to this topic
Not an expert but use it regularly