Hi,

Need some help. I am trying to sum only when there is a non-zero value in a cell. I do not want anything to populate on the cell unless there is a value over or under 0 on another cell. The problem that I am having is that there are zeros on the cells (I am using accounting formatting) because there are formulas that populate from other spreadsheets. I am using the following formula: =IF(E10="0","",SUM(E14-E9)).

What do I need to do to be able to sum only if there is a value less than or greater than 0 in E10, or what about if I need another cell too (i.e. E11). I have validations set up on my worksheets to light up only when I have values and I am trying to get my worksheet to reflect current data please help

Thanks,
Natalee