Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add total items in from another worksheet?
I need help with a formula for my inventory master list.
I have several worksheets, the one I need a total from is the Inventory in Worksheet. Everytime we purchase an item and enter it into my Inventory In sheet I want it to do a total of how many of that item we have purchased all year in my Inventory Report sheet. Lookup quantities of an item in another worksheet to give a total in another. Sorry if my wording is erratic, I have hard time explaining but know what I need. Some sort of eg; Inventory In; Item Qty In 149 10 160 10 155 10 149 30 155 20 Inventory Report; Item Totals 149 40 160 10 155 30 Thanks; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wanting to check off items and have it add them to a total value | Excel Discussion (Misc queries) | |||
Running Total per group of items | Excel Worksheet Functions | |||
Total different items from one column with reference to another? | Excel Discussion (Misc queries) | |||
Total Items Per Hour | Excel Discussion (Misc queries) | |||
How to total like items | Excel Discussion (Misc queries) |