what excel formula will perform a running subtract from one value

A

AMcV

I have one value and under it i have a number of smaller values that when i
enter into a cell i want them to automatically subtract from the top value?
 
B

Bob Phillips

In B2

=$A$1-SUM($A$2:$A2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

AMcV said:
I have one value and under it i have a number of smaller values that when i
enter into a cell i want them to automatically subtract from the top
Click to expand...
value?
 
Top