Hi, hope i can explain this in a reasonable way.

I have a worksheet with lots of product orders along with the
quantities of each part in each order.

Each part is duplicated many times, so an example would be this

Product Quantity
CD 11016 3
CD 11017 10
DVD 11006 0
CD 11016 2
VCD 11043 11
MP3 11052 12
DVD 11006 4
DVD 11008 6
DVD 11008 2
CD 11016 13

I need to create a new sheet which looks up each individual item, and
then next to that tells me the total quantity of that item that was
ordered. I'm sure there's an easy way to do this but can't for the life
of me think how to do it

Any help greatly appreciated!


--
andymaw11
------------------------------------------------------------------------
andymaw11's Profile: http://www.excelforum.com/member.php...o&userid=35931
View this thread: http://www.excelforum.com/showthread...hreadid=557243

managed to find a way using subtotals, not a formula like i was after,
but it does the job


--
andymaw11
------------------------------------------------------------------------
andymaw11's Profile: http://www.excelforum.com/member.php...o&userid=35931
View this thread: http://www.excelforum.com/showthread...hreadid=557243

andymaw11 wrote:

I need to create a new sheet which looks up each individual item, and
then next to that tells me the total quantity of that item that was
ordered.

Hi andy

Try this

=SUM(IF(A1=Sheet1!$A$1:$A$10,(Sheet1!$B$1:$C$10)))

Adjust the ranges and sheet reference as required.

This is an array formula so type it in an confirm it by pressing
Ctrl+Shift+Enter.

Regards

Steve