excel formula won't copy down

  • Thread starter Thread starter Janet T
  • Start date Start date
J

Janet T

=sum(c1-a2+b2). Just a simple formula for keeping track of cks for bank
statement. Have used it for well over a year with MSC Office Home and
Student, now it does not want to copy down and add and subtract numbers. I
even uninstalled it and reinstalled it. Help, please?
 
What exactly do you mean by "does not want to copy down." Does Excel not
show the fill handle or does the copy/paste functions not work? Or does the
function copy but not evaluate at all, or correctly?
 
It copies , but does not calculate the answer. I even tried typing the full
formula into each decending cell. Changed original starting amount and the
formulas did not calculate a new answer. Apparentlly the copy & paste are
not functioning. Cause when I C&P the answer stays the same as where it was
copied down from. So any help is appreciated. Janet
 
11-11-09 found my way around problem. opened a new excel copied my a&b
columns, keyed in starting $ then put my formula in for =sum(c1-a2+b2) and my
C&P plus the calculation all worked just fine. will reread the notes you
fellows gave me and check them out in my old excel. when i was working with
FRAMEWORK IV in 1985 i had to teach my self alot of short cuts to get around
problema that i really didn't have the answer. so thank for the info you
have given me. it is appreciated
 
Back
Top