Totals of each product in a new worksheet

[andymaw11]

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
CD11016 3
CD11017 10
DVD11006 0
CD11016 2
DVD11006 4
DVD11008 6
DVD11008 2
CD11016 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]

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

[Scoops]

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