View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK[_8_] Pete_UK[_8_] is offline
external usenet poster
 
Posts: 25
Default Firstly get rid of the unnecessary SUM() function.

Ragu,

Is it really necessary to respond to a post that is nearly three years
old?

Pete

On Oct 1, 10:47*am, Ragu Binu wrote:
Check the cell value it might be stored as "numbers stored as Text" change that to "Convert to Numbers" by clicking the dialouge box or else you format the entire row or column in numbers and then re enter the value of each cell and then do autosumation you will get the correct answer..

hoe it will be usefull....

Ragu.....