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