Autosum and Sum functions not totalling properly

[Don Guillett]

try changing the cells to their values
Sub FixRangeValues()
Selection.Value = Selection.Value
End Sub
or
copy>paste>special values

--
Don Guillett
SalesAid Software
(e-mail address removed)

I am trying to total the numbers in a column using Autosum or the Sum

function. For some reason it is only coming up with a "0" total. I have
checked the formatting in the cells to make sure it was correct and made
sure that the functions update automatically and everything seems fine
there. The columns next to this column are totalling properly. I cannot
figure out what is wrong. Help!!

 

[bdorwart]

I am trying to total the numbers in a column using Autosum or the Sum function. For some reason it is only coming up with a "0" total. I have checked the formatting in the cells to make sure it was correct and made sure that the functions update automatically and everything seems fine there. The columns next to this column are totalling properly. I cannot figure out what is wrong. Help!!