software

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 9Any formula for this?

Thanks for the help

Chris--
cj21
------------------------------------------------------------------------
cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=512664A pivot table is exactly what you want. See:

peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Studentquot;cj21quot; wrote:

gt;
gt; I have a list of products and corresponding values as follows:
gt;
gt; Product Value
gt; 01 10
gt; 01 12
gt; 01 16
gt; 02 41
gt; 02 17
gt; 03 4
gt; 03 5
gt;
gt; I want a formula that adds up the values for each cattogry. In
gt; otherwords i want a new table like:
gt;
gt; Product Value
gt; 01 38
gt; 02 58
gt; 03 9
gt;
gt;
gt; Any formula for this?
gt;
gt; Thanks for the help
gt;
gt; Chris
gt;
gt;
gt; --
gt; cj21
gt; ------------------------------------------------------------------------
gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; View this thread: www.excelforum.com/showthread...hreadid=512664
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=512664You 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 --gt;
Subtotals) for a change in your product, sum the quantity field.

Best of luck!

quot;cj21quot; wrote:

gt;
gt; Thanks for the advice. But at the moment i don't really have time to
gt; learn pivot tables. Any chance of a formula?
gt;
gt; Chris
gt;
gt;
gt; --
gt; cj21
gt; ------------------------------------------------------------------------
gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; View this thread: www.excelforum.com/showthread...hreadid=512664
gt;
gt;



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
110IF($B21,$C2,quot;quot;)IF($B22,$C2,quot;quot;)IF($B23,$C2,quot;quot;)
112IF($B31,$C3,quot;quot;)IF($B32,$C3,quot;quot;)IF($B33,$C3,quot;quot;)
116IF($B41,$C4,quot;quot;)IF($B42,$C4,quot;quot;)IF($B43,$C4,quot;quot;)
241IF($B51,$C5,quot;quot;)IF($B52,$C5,quot;quot;)IF($B53,$C5,quot;quot;)
217IF($B61,$C6,quot;quot;)IF($B62,$C6,quot;quot;)IF($B63,$C6,quot;quot;)
34IF($B71,$C7,quot;quot;)IF($B72,$C7,quot;quot;)IF($B73,$C7,quot;quot;)
35IF($B81,$C8,quot;quot;)IF($B82,$C8,quot;quot;)IF($B83,$C8,quot;quot;)quot;TRquot; wrote:

gt; You could try subtotals. You need to have column headings for your table,
gt; and your table needs to be sorted. Then you could set up subtotals (Data --gt;
gt; Subtotals) for a change in your product, sum the quantity field.
gt;
gt; Best of luck!
gt;
gt; quot;cj21quot; wrote:
gt;
gt; gt;
gt; gt; Thanks for the advice. But at the moment i don't really have time to
gt; gt; learn pivot tables. Any chance of a formula?
gt; gt;
gt; gt; Chris
gt; gt;
gt; gt;
gt; gt; --
gt; gt; cj21
gt; gt; ------------------------------------------------------------------------
gt; gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=512664
gt; gt;
gt; gt;

Ooops.... I was missing the '=' signs !!!

=IF($B2=1,$C2,quot;quot;) =IF($B2=2,$C2,quot;quot;)=IF($B2=3,$C2,quot;quot;)
=IF($B3=1,$C3,quot;quot;)=IF($B3=2,$C3,quot;quot;)=IF($B3=3,$C3,quot;quot;)
=IF($B4=1,$C4,quot;quot;)=IF($B4=2,$C4,quot;quot;)=IF($B4=3,$C4,quot;quot;)
=IF($B5=1,$C5,quot;quot;)=IF($B5=2,$C5,quot;quot;)=IF($B5=3,$C5,quot;quot;)
=IF($B6=1,$C6,quot;quot;)=IF($B6=2,$C6,quot;quot;)=IF($B6=3,$C6,quot;quot;)
=IF($B7=1,$C7,quot;quot;)=IF($B7=2,$C7,quot;quot;)=IF($B7=3,$C7,quot;quot;)
=IF($B8=1,$C8,quot;quot;)=IF($B8=2,$C8,quot;quot;)=IF($B8=3,$C8,quot;quot;)quot;TRquot; wrote:

gt; You could try subtotals. You need to have column headings for your table,
gt; and your table needs to be sorted. Then you could set up subtotals (Data --gt;
gt; Subtotals) for a change in your product, sum the quantity field.
gt;
gt; Best of luck!
gt;
gt; quot;cj21quot; wrote:
gt;
gt; gt;
gt; gt; Thanks for the advice. But at the moment i don't really have time to
gt; gt; learn pivot tables. Any chance of a formula?
gt; gt;
gt; gt; Chris
gt; gt;
gt; gt;
gt; gt; --
gt; gt; cj21
gt; gt; ------------------------------------------------------------------------
gt; gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=512664
gt; gt;
gt; gt;