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

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

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

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