The copy down function for autosum gives wrong answers

  • Thread starter Thread starter franky
  • Start date Start date
F

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
 
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
Click to expand...

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

Lars-Åke
 
Lars-Ã…ke Aspelin said:
What are the data you have in the cells and what are your expected
outputs from these formulas?

Lars-Ã…ke
Click to expand...


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
 
Try setting calculation mode to Automatic.

Tools>Options>Calculation.


Gord Dibben MS Excel MVP
 
Gord Dibben said:
Try setting calculation mode to Automatic.

Tools>Options>Calculation.


Gord Dibben MS Excel MVP
Click to expand...


Thank you very much. I get it.

Have a nice day !!!

Franky
 
Back
Top