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

Perhaps something like =IF(E10="","",E14-E9) ?
If not please post a sample sheet showing what you have and expected results

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer,

I would like for my over/under to populate only when I have actual totals and not when there is a zero value. The actuals get populated every two weeks from another spreadsheet.

November December January
Budgeted $1000 $1400 $1200
Actuals $750 $0.00 $0.00
Over/Under $250 $1400 $1200

Thanks,
Natalee

Please post a sheet -Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post