Thread: [Solved] Trying to sum only when there is a non-zero value on cell - please help
View Single Post
 
Old 12-03-2014, 07:08 PM
Natalee Natalee is offline Windows 8 Office 2013
Novice
  
Join Date: Nov 2014
Posts: 6
Natalee is on a distinguished road
Default
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
Reply With Quote