0

In the worksheet below:

  • Previous Count is 630 (B4).
  • I then received 100 items (E4).
  • New stock count is 729 (C4), because I sold 1 item.

Laid out like this:

       B             C         D            E          F
Previous Count  Stock Take  Shipped  Stock Received  Total
630                 729       -99          100        729
Column A is the product ID/item name.  "Stock take" just means my current/live count (inventory) of the item.

I know I have shipped 1 item, but I don't have records (data) to support this; therefore, I'm trying to compute it. I have =SUM(B4-C4) in cell D4, but Excel shows this as -99. How do I fix this formula to show 1?

I've probably had too little sleep because I just can't figure out what the formula or format of the cell should be.

enter image description here

Scott - Слава Україні
  • 22,532

2 Answers2

0

It seems that you are forgetting to add the "Stock Received" cell into your sum. This can easily be fixed by adding +E4 into the function.

Also, SUM is repetitive since it's goal it to add cells or ranges of cells.

From the Official Office Documentation, the definition of SUM is as follows:

The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three.

So in your function, you are evaluating B4-C4 and then adding it to nothing.

In conclusion, your function should be: =B4-C4+E4.

Jackie Chen
  • 1
-1

You can try this: 

=SUM(B4-C4+E4)

?

marx
  • 22