The MID function is a text function and will leave the "numbers" as text.

I don't know what MID formula you used, but you could probably add a *1
which forces the text to numeric.

e.g. =MID(H3,3,2)*1


Gord

On Tue, 9 Dec 2008 05:56:35 -0800, ChewinFoil
wrote:

I already tried SUM on range but result is zero. But I was using the MID
function solely, I'll try Chip's code instead, thanks.