Excel formula reverting back to blank once i double click on individual cells

[kali86]

Please see file below.

Any help would be appreciated.

 

[kali86]

Account Number <colgroup><col width="183" style="width:137pt"> </colgroup><tbody> </tbody> <strike></strike>	<strike></strike> Total Consolidated Amount(Formulated <colgroup><col width="183" style="width:137pt"> </colgroup><tbody> </tbody>
100100 <colgroup><col width="183" style="width:137pt"></colgroup><tbody> </tbody> <strike></strike>	-
100101	242.40
100103	536

<tbody>
</tbody>

Example=formula=sumif(…), once I click once I hit enter on the formulated cell, it goes to being zero. I could attach a sample file, but I cannot attach it. So example above. Again,

once I hit enter(formula on the total consolidated amount) goes blank.​