hi i am vishnu lakhani i am not able to make sum out in column, when i am trying this it always taken as count. even when i moves the raw in  values it become automatically zero. 

• Moved by Lanlan HuangMicrosoft contingent staff Wednesday, July 15, 2015 1:48 AM

hi i am vishnu lakhani i am not able to make sum out in column, when i am trying this it always taken as count. even when i moves the raw in  values it become automatically zero. 

See if my answer here:-

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/not-able-to-get-the-sum-of-the-values-it-returns/f1431f5e-5954-43e7-b368-4b17eb2989ab?auth=1

 - resolves your problem.