Were the numbers with a decimal actually text?
If so you could turn them into numbers then sum them
if =Sum(A1:A5) doesnt work try =sum(A1*1,A2*1,A3*1,A4*1,A5*1)
multiplying by 1 turns the text back into a number.
I know this is an old post, but it was un-answered.
TT