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