Inventory Formula

K

Karen

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
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing after a long formula 5
Copying formulas across columns 2
Help with calculating time and a half - I've got straight time and double time. 4
Format part of text in concatenated field 4
Inventory List 3
Formatting a spreadsheet to calculate difference in dates etc. 2
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
how do I create a nonadjacent series for autofill to go by? 3

Top