# Quantity from second worksheet

#### Trevor Kaltenbrunn

##### New Member

I have a worksheet entitled Sales and i have a second Sheet for a summary of sales YEARLY SALES by item. Sales worksheet SALES has 8 columns ( Invoice,date,item, Quantity, Description,Ect). In the second worksheet i would like to check a certain item in Sales worksheet and see how many have been sold.

In Sales worksheet column 3 has item and column 4 has amount soled. If i now have multiple row entries of the same item i need the value of that items total sold amount to be displayed in the summary sheet, next to the item header.

If you see example below, in SALES Column 3 i have labour Twice, i need to check the total of the labour sold in Column 2 YEARLY SALES

Sales Workbook

 Inv Nu Date Item Qty Description 1 2 Labour 4 Labour 2 Call Out 1 Call Out 3 Pen 7 Pen 4 Labour 8 Labour

<tbody>
</tbody>

Yearly Sales

 Labour ? Call Out ? Pen ? ? ?

<tbody>
</tbody>

Thanks

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

try

#### Trevor Kaltenbrunn

##### New Member
try

ABCDEFGH
1Inv NuDateItemQtyDescriptionYearly Sales
212Labour4LabourLabour12
32Call Out1Call OutCall Out1
43Pen7PenPen7
54Labour8Labour

</tbody>
Sheet1

Worksheet Formulas
CellFormula
H2=SUMIF(C:C,G2,D:D)

</tbody>

<tbody>
</tbody>

Hi Alan

What can i do if they are on seperate worksheets. I want the results your column H in a seperate worksheet.

#### AlanY

##### Well-known Member
the easiest way is create them in the same sheet, cut and paste the columns (e.g. G & H) to the new sheet, excel will adjust the reference automatically

#### Trevor Kaltenbrunn

##### New Member
Thanks, i got it working.

Replies
11
Views
169
Replies
1
Views
70
Replies
1
Views
48
Replies
0
Views
55
Replies
0
Views
183

### Forum statistics

1,128,064
Messages
5,628,391
Members
416,315
Latest member
certainlyfrustrated

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back