I have a spreadsheet that has pulled data from the database into sheet 1. In
sheet 2 i want excel to tell me how much of each product code and the total
quantity of that product code was picked. Example 00048003 is the product
code and then l have x amont of rows with a quantity next to it. I want to
siphon it done like below
00048003 = 2500 cartons
00447006 = 500 cartons
00449006 = 50 cartons and so on
the data can be refereshed at a later time which then l would like excel to
update sheet 2 with this information?
thanks in advance.
--
chris

Assuming your product codes are in column A of both sheets, and the
quantities in column B, then put this formula in B1 of Sheet2:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

Copy down to cover the data you have in column A.

Hope this helps.

Pete

On Nov 16, 8:44 am, hotlh wrote:
I have a spreadsheet that has pulled data from the database into sheet 1. In
sheet 2 i want excel to tell me how much of each product code and the total
quantity of that product code was picked. Example 00048003 is the product
code and then l have x amont of rows with a quantity next to it. I want to
siphon it done like below
00048003 = 2500 cartons
00447006 = 500 cartons
00449006 = 50 cartons and so on
the data can be refereshed at a later time which then l would like excel to
update sheet 2 with this information?
thanks in advance.
--
chris

Thanks Pete for the response but the data is in column E sheet 1 for the
product codes and sheet 1 column W. So do l have put the results back into
both columns of sheet 2? or can l put the results into sheet 2 column A and
then column B? Thanks
--
chris


"Pete_UK" wrote:

Assuming your product codes are in column A of both sheets, and the
quantities in column B, then put this formula in B1 of Sheet2:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

Copy down to cover the data you have in column A.

Hope this helps.

Pete

On Nov 16, 8:44 am, hotlh wrote:
I have a spreadsheet that has pulled data from the database into sheet 1. In
sheet 2 i want excel to tell me how much of each product code and the total
quantity of that product code was picked. Example 00048003 is the product
code and then l have x amont of rows with a quantity next to it. I want to
siphon it done like below
00048003 = 2500 cartons
00447006 = 500 cartons
00449006 = 50 cartons and so on
the data can be refereshed at a later time which then l would like excel to
update sheet 2 with this information?
thanks in advance.
--
chris

Your results will appear in whichever column you put the formula, so
in Sheet2 put your product codes in column A and the formula in column
B:

=SUMIF(Sheet1!E:E,A1,Sheet1!W:W)

which means add up the values in Sheet1 column W IF the code in Sheet1
column E matches the code in A1 (of sheet2). Copy down as required,
with other product codes in column A.

Hope this helps.

Pete

On Nov 19, 4:36 am, hotlh wrote:
Thanks Pete for the response but the data is in column E sheet 1 for the
product codes and sheet 1 column W. So do l have put the results back into
both columns of sheet 2? or can l put the results into sheet 2 column A and
then column B? Thanks
--
chris



"Pete_UK" wrote:
Assuming your product codes are in column A of both sheets, and the
quantities in column B, then put this formula in B1 of Sheet2:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

Copy down to cover the data you have in column A.

Hope this helps.

Pete

On Nov 16, 8:44 am, hotlh wrote:
I have a spreadsheet that has pulled data from the database into sheet 1. In
sheet 2 i want excel to tell me how much of each product code and the total
quantity of that product code was picked. Example 00048003 is the product
code and then l have x amont of rows with a quantity next to it. I want to
siphon it done like below
00048003 = 2500 cartons
00447006 = 500 cartons
00449006 = 50 cartons and so on
the data can be refereshed at a later time which then l would like excel to
update sheet 2 with this information?
thanks in advance.
--
chris- Hide quoted text -

- Show quoted text -