| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Formula
I'm trying to keep track of inventory using Excel. In B2, I have Initial
Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is dept. A, D2 is dept. B, E2 is dept. C, F2 is dept. D. If my initial qty. is 500, then I issue 25 to each dept. my remaining inventory should be 400. In cell G2, I have =SUM(C2:F2)-B2. It's returning a -400 and it should be positive 400. What is going on here? Any help would be greatly appreciated. Thank you, Karen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inventory Formula
Hi Karen
use the formula the other way =B2-sum(C2:F2) "Karen" wrote: I'm trying to keep track of inventory using Excel. In B2, I have Initial Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is dept. A, D2 is dept. B, E2 is dept. C, F2 is dept. D. If my initial qty. is 500, then I issue 25 to each dept. my remaining inventory should be 400. In cell G2, I have =SUM(C2:F2)-B2. It's returning a -400 and it should be positive 400. What is going on here? Any help would be greatly appreciated. Thank you, Karen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inventory Formula
DUH! I better get some coffee!
Thank you so much, Karen "Eduardo" wrote: Hi Karen use the formula the other way =B2-sum(C2:F2) "Karen" wrote: I'm trying to keep track of inventory using Excel. In B2, I have Initial Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is dept. A, D2 is dept. B, E2 is dept. C, F2 is dept. D. If my initial qty. is 500, then I issue 25 to each dept. my remaining inventory should be 400. In cell G2, I have =SUM(C2:F2)-B2. It's returning a -400 and it should be positive 400. What is going on here? Any help would be greatly appreciated. Thank you, Karen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inventory Formula
Your welcom, don't worry it happens to me sometimes, when I am so
concentrated in something I don't see what is supposed to be obvious "Karen" wrote: DUH! I better get some coffee! Thank you so much, Karen "Eduardo" wrote: Hi Karen use the formula the other way =B2-sum(C2:F2) "Karen" wrote: I'm trying to keep track of inventory using Excel. In B2, I have Initial Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is dept. A, D2 is dept. B, E2 is dept. C, F2 is dept. D. If my initial qty. is 500, then I issue 25 to each dept. my remaining inventory should be 400. In cell G2, I have =SUM(C2:F2)-B2. It's returning a -400 and it should be positive 400. What is going on here? Any help would be greatly appreciated. Thank you, Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel IF Formula for an inventory... | Excel Discussion (Misc queries) | |||
| Formula needed for too much inventory | Excel Worksheet Functions | |||
| inventory comparison formula?? | Excel Worksheet Functions | |||
| Need help with a formula in inventory | Excel Discussion (Misc queries) | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Hybrid Mode
