The copy down function for autosum gives wrong answers
 

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x

The copy down function for autosum gives wrong answers
 

On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote:

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x

What are the data you have in the cells and what are your expected
outputs from these formulas?

Lars-Åke

The copy down function for autosum gives wrong answers
 

"Lars-Ã…ke Aspelin" wrote:

On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote:

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x

What are the data you have in the cells and what are your expected
outputs from these formulas?

Lars-Ã…ke



Thank you for your prompt response, Lar-Ake

I found the something wrong with the copy down function in the work wheet.

They are just numbers and caculations

The copy down function for autosum gives wrong answers
 

Try setting calculation mode to Automatic.

ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote:

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x

The copy down function for autosum gives wrong answers
 

"Gord Dibben" wrote:

Try setting calculation mode to Automatic.

ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote:

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x




Thank you very much. I get it.

Have a nice day !!!

Franky