Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AUTO SUM
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 -- |
#2
|
|||
|
|||
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? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "assi" wrote in message ... 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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Correct ? | Excel Discussion (Misc queries) | |||
Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |