The copy down function for autosum gives wrong answers

[franky]

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

 

[Lars-Åke Aspelin]

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

 

[franky]

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

 

[Gord Dibben]

Try setting calculation mode to Automatic.

Tools>Options>Calculation.


Gord Dibben MS Excel MVP

 

[franky]

Try setting calculation mode to Automatic.

Tools>Options>Calculation.


Gord Dibben MS Excel MVP

Thank you very much. I get it.

Have a nice day !!!

Franky