Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inventory Sheet
I am putting together a medication inventory sheet. The fields I am trying to
calculate are as follows: C Units Issued G Units Added H Total Units in Stock L Yearly Total What I would like to do is keep a running inventory total. I want to have the Total Units in Stock to be the sum of the Units Added minus the Units Issued which I can do. However,I need to then have the Total Units in Stock remain constant and be continually updated after each calculation is performed. As of right now every time I change Units Added or Units Issued the Total in Stock changes only to reflect the two new number I entered. I need to have the Total in Stock reflect the sum of the current Units Added - Units Issued as well as the sum of the previous Total in Stock calculation. Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inventory Sheet
Personally, I think I would use a separate row for each transaction, whether
it be an "issue" or an "add", and then use other Excel features such as AutoFilter or SUMIF or SUMPRODUCT, etc to get/display the totals reports and number of transactions of each type, etc...... Vaya con Dios, Chuck, CABGx3 "Medic 803" wrote: I am putting together a medication inventory sheet. The fields I am trying to calculate are as follows: C Units Issued G Units Added H Total Units in Stock L Yearly Total What I would like to do is keep a running inventory total. I want to have the Total Units in Stock to be the sum of the Units Added minus the Units Issued which I can do. However,I need to then have the Total Units in Stock remain constant and be continually updated after each calculation is performed. As of right now every time I change Units Added or Units Issued the Total in Stock changes only to reflect the two new number I entered. I need to have the Total in Stock reflect the sum of the current Units Added - Units Issued as well as the sum of the previous Total in Stock calculation. Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally Fill a sheet row if cell value in another sheet 0 | Excel Worksheet Functions | |||
How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how do i set u a inventory sheet for a vending mahine | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Worksheet Functions |