Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
I have a list of products and corresponding values as follows: Product Value 01 10 01 12 01 16 02 41 02 17 03 4 03 5 I want a formula that adds up the values for each cattogry. In otherwords i want a new table like: Product Value 01 38 02 58 03 9 Any formula for this? Thanks for the help Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
A pivot table is exactly what you want. See:
http://peltiertech.com/Excel/Pivots/pivotstart.htm -- Gary's Student "cj21" wrote: I have a list of products and corresponding values as follows: Product Value 01 10 01 12 01 16 02 41 02 17 03 4 03 5 I want a formula that adds up the values for each cattogry. In otherwords i want a new table like: Product Value 01 38 02 58 03 9 Any formula for this? Thanks for the help Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
Thanks for the advice. But at the moment i don't really have time to learn pivot tables. Any chance of a formula? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
You could try subtotals. You need to have column headings for your table,
and your table needs to be sorted. Then you could set up subtotals (Data -- Subtotals) for a change in your product, sum the quantity field. Best of luck! "cj21" wrote: Thanks for the advice. But at the moment i don't really have time to learn pivot tables. Any chance of a formula? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
you could use this, but the more Product you have, the more columns you will need to use. You can then total up the columns of each product (1, 2, 3...etc) A B C D E Product Value 1 2 3 1 10 IF($B21,$C2,"") IF($B22,$C2,"") IF($B23,$C2,"") 1 12 IF($B31,$C3,"") IF($B32,$C3,"") IF($B33,$C3,"") 1 16 IF($B41,$C4,"") IF($B42,$C4,"") IF($B43,$C4,"") 2 41 IF($B51,$C5,"") IF($B52,$C5,"") IF($B53,$C5,"") 2 17 IF($B61,$C6,"") IF($B62,$C6,"") IF($B63,$C6,"") 3 4 IF($B71,$C7,"") IF($B72,$C7,"") IF($B73,$C7,"") 3 5 IF($B81,$C8,"") IF($B82,$C8,"") IF($B83,$C8,"") "TR" wrote: You could try subtotals. You need to have column headings for your table, and your table needs to be sorted. Then you could set up subtotals (Data -- Subtotals) for a change in your product, sum the quantity field. Best of luck! "cj21" wrote: Thanks for the advice. But at the moment i don't really have time to learn pivot tables. Any chance of a formula? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding easy
Ooops.... I was missing the '=' signs !!!
=IF($B2=1,$C2,"") =IF($B2=2,$C2,"") =IF($B2=3,$C2,"") =IF($B3=1,$C3,"") =IF($B3=2,$C3,"") =IF($B3=3,$C3,"") =IF($B4=1,$C4,"") =IF($B4=2,$C4,"") =IF($B4=3,$C4,"") =IF($B5=1,$C5,"") =IF($B5=2,$C5,"") =IF($B5=3,$C5,"") =IF($B6=1,$C6,"") =IF($B6=2,$C6,"") =IF($B6=3,$C6,"") =IF($B7=1,$C7,"") =IF($B7=2,$C7,"") =IF($B7=3,$C7,"") =IF($B8=1,$C8,"") =IF($B8=2,$C8,"") =IF($B8=3,$C8,"") "TR" wrote: You could try subtotals. You need to have column headings for your table, and your table needs to be sorted. Then you could set up subtotals (Data -- Subtotals) for a change in your product, sum the quantity field. Best of luck! "cj21" wrote: Thanks for the advice. But at the moment i don't really have time to learn pivot tables. Any chance of a formula? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=512664 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel |