I am not sure I understand you but you might want to check "extend list
formats and formulas" under toolsoptionsedit

--

Regards,

Peo Sjoblom

"Pam Coleman" wrote in message
...
If I have numbers in col a and col b and I have a formula in col c that is
a1-b1, then in c2, I have the same formula + what is added in c1, and the
same all the way down, (keeping a running total). Question, is there a
way
to have in col c an automatically way to have the formula without me
having
to drag or copy down, so when I type in the numbers in a and b it will run
the formula and keep the running total from the cell above.