AUTO SUM

[Guest]

Hi everybody!

Can anybody tell me a formula or function. I am try to create auto sum.

Just say I create a column with auto sum function. Can I make it chage
later, if I insert with new column with new data?

Example: =A2-B2,C2D2 auto Balance, but it is not chaging if I insert with
new column with new data I need to chage the Balance autometicaly.


Sincerely!
assi

--

 

[JulieD]

Hi

not sure exactly what you're after here

if you have the formula in C2
=A2-B2
and you insert a column between A & B (moving your formula to D2) the
formula would automatically adjust to
=A2-C2
so you do want it to be
=A2-B2-C2
or
=A2-(B2+C2)
or something else entirely

the other thing that "concerns" me is that i would generally expect this
sort of calculation to be done down rows as you only have 256 columns ... is
that enough to cater for future growth of your worksheet?