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.....
|