AUTO SUM

A

assi

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

--
 
J

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?
 
Top