New to Excel and need help with subtract multiple cells for one cell

**rpbrown88** · 11-13-2013, 08:45 PM

Hi - thanks whoever helps. I am totally new to Excel (using2010)
OK here it is:

I would like a formula where I have a worker enter a number in a cell. For instance he wants to enter it in yards total before he begins ( that number varies so it has to be blank waiting an entry)
Next in a column are cells where he enters the yards used on a run - these cells total at the bottom.

So on the one sheet I am trying:
D4 is to be blank and where the worker will enter a number
B10 through B29 will be where they enter the number of yards used. They may use only one of these cells or all.

So the number in D4 should decrease based on the values entered in B10 and subsequent cells. So if he types 3500 in D4 and then types 250 in B10 D4 should now read 3250.

Does this make sense and you can send it to my email if you like rpbrown88@comcast.net

Thank you so very much - what a nice site to have!

**dredwolf** · 11-13-2013, 08:56 PM

You can not enter a number AND a formula in the same cell, you could simulate it through vba I suppose, but the easiest way would be something like this,
D4 = total yards
B10-B29 = yards used
D5 (or maybe E4, up to you

) = yards remaining
then in the yards remaining cell, this formula :

Formula:

Please Login or Register  to view this content.

as you enter values into B10-29, the value in your yards remaining cell will decrease
You would have to erase the cells (B10-29 and D4) for each project, or set up different sheets/areas for each project, but the basic formula is still the same

Hope this helps