what excel formula will perform a running subtract from one value
 

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?

what excel formula will perform a running subtract from one value
 

In B2

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

--

HTH

Bob Phillips

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

"AMcV" wrote in message
...
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?