Macro for summing

Hi Guys,

I have a problem. I am summing a column where the end result should be zero (debit + credit). This column is referenced from another worksheet. ROUND(SUM(JV_LineItems!O6:O1004),Item_LCDecimal) is the formula used. But this is showing an error (#value) instead of zero. The error is coming due to the fact that in some cells it has the referenced cell present. Also it could be due to the macro written (attaching the macro file).
Could someone help in this. I posted this topic in Excel Misc. , but as it is a macro issue – I am moving this topic here.

Thanks a lot.
Regards,
Indira