Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 9th 09, 09:41 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 2
Default excel formula won't copy down

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

  #2   Report Post  
Old November 9th 09, 09:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default excel formula won't copy down

"sum" is redundant.

Janet T wrote:

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


  #3   Report Post  
Old November 9th 09, 09:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default excel formula won't copy down

Well, to start with you might explain to us what you are expecting the SUM
function to do in that formula. You have calculated C1-A2+B2, but you
haven't told Excel what it is that you want SUM to add to that result. Or
did you intend the formula just to be =C1-A2+B2 ? If you don't understand
what the SUM function does, look it up in Excel help.

You haven't told us what happens when you copy the formula down. Is the
cell just displaying the formula, or are all the cells showing you the
result from the first row?
If the former, check whether you've applied the option to view formulas, and
then check whether the cell is formatted as text. If formatted as text,
format as general and then re-enter the formula.
If the latter (i.e. all cells showing results from first row), check that
you've got Tools/ Options/ Calculation showing Automatic, not Manual.
--
David Biddulph

"Janet T" <Janet wrote in message
...
=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?



  #4   Report Post  
Old November 9th 09, 10:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 4
Default excel formula won't copy down

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?




"Janet T" wrote:

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

  #5   Report Post  
Old November 10th 09, 01:01 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2,389
Default excel formula won't copy down

You probably have recalculation set to manual.

Regards,
Fred

"Janet T" <Janet wrote in message
...
=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?




  #6   Report Post  
Old November 10th 09, 02:07 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 3
Default excel formula won't copy down

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

"Anthony Fontana" wrote:

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?




"Janet T" wrote:

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

  #7   Report Post  
Old November 10th 09, 08:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default excel formula won't copy down

As I and others have suggested earlier, it sounds as if calculation mode is
set to manual. Have you checked?
--
David Biddulph

"Janet T" wrote in message
...
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

"Anthony Fontana" wrote:

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?




"Janet T" wrote:

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



  #8   Report Post  
Old November 11th 09, 07:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 3
Default excel formula won't copy down

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

"Janet T" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula to copy every nth row Van Excel Worksheet Functions 1 November 5th 08 08:21 AM
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
Copy formula in excel shee Excel Discussion (Misc queries) 4 March 28th 07 02:45 AM
Copy formula in excel shee Excel Discussion (Misc queries) 0 March 28th 07 12:00 AM
Excel Formula Copy Jennifer Excel Discussion (Misc queries) 2 January 5th 06 06:02 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017