Hi!

I have been using Excel for years. My spreadsheets use very simple formulas, but this one has me stumped.

I use Excel to track inventory. As orders are fulfilled, I want the total to reduce. My beginning inventory figure is 100. Each sale will be entered in the next cell below - B2, B3, etc.

Snap 2021-09-28 at 12.01.31.jpg

#VALUE! is the result of the formula. But if I enter the formula as: +100-B1-B2-B3....etc., the correct result is returned.

What am I missing??

Thank for any and all help.

Doug