[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 183"]
<colgroup><col width="183" style="width:137pt"> </colgroup><tbody>[TR]
[TD="width: 183, bgcolor: transparent"]
Account Number[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD]<strike></strike>[TABLE="width: 183"]
<colgroup><col width="183" style="width:137pt"> </colgroup><tbody>[TR]
[TD="width: 183, bgcolor: #FFFF00"]
Total Consolidated Amount(Formulated[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 183"]
<colgroup><col width="183" style="width:137pt"></colgroup><tbody>[TR]
[TD="width: 183, bgcolor: transparent, align: right"]
100100[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD]-[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 100101[/TD]
[TD]242.40[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 100103[/TD]
[TD]536[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.