formula question

P

Pam Coleman

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.
 
P

Peo Sjoblom

I am not sure I understand you but you might want to check "extend list
formats and formulas" under tools>options>edit
 
A

Adam Harris

starting in row 2 you could try:

C2 =A2-B2+C1

Peo Sjoblom said:
I am not sure I understand you but you might want to check "extend list
formats and formulas" under tools>options>edit

--

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top