View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
franky franky is offline
external usenet poster
 
Posts: 8
Default 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