Trevor Kaltenbrunn
New Member
- Joined
- Feb 2, 2019
- Messages
- 9
Hi Please help,
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
<tbody>
</tbody>
Yearly Sales
<tbody>
</tbody>
Thanks
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