View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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