As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?
--
Chris

Show us what the formula looks like? Wonder it you have absolute references.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"chris pugh" <Cheshire UK wrote in message
...
As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual
cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?
--
Chris

I'm thinking maybe calculation got set to manual. Does F9 update the
formulas? Go to Tools-Options-Calculation and check Automatic.
--
Kevin Vaughn


"Bernard Liengme" wrote:

Show us what the formula looks like? Wonder it you have absolute references.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"chris pugh" <Cheshire UK wrote in message
...
As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual
cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?
--
Chris

Hi Chris,

I am now having the same problem you experienced. Have you solved that
problem? Do you mind to share the trick?:-) Thanks,

Grace

"chris pugh" wrote:

As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?
--
Chris

Here are a couple of things to look at.

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomatic

Your formulas might be using absolute referencing when they should be using
relative referencing. For example:

=SUM(A$1:B$1)

When you copy that formula down a column the references don't change so all
copies will return the same result.

=SUM(A1:B1)

When you copy that formula down a column the references will change so all
copies will return the expected result.

--
Biff
Microsoft Excel MVP


"Grace" wrote in message
...
Hi Chris,

I am now having the same problem you experienced. Have you solved that
problem? Do you mind to share the trick?:-) Thanks,

Grace

"chris pugh" wrote:

As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual
cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?
--
Chris