Trying to sum only when there is a non-zero value on cell

		Microsoft Office Forums > Microsoft Excel > Excel
Trying to sum only when there is a non-zero value on cell - please help

FAQ

Thread Tools

Display Modes

12-03-2014, 07:08 PM

Natalee

Trying to sum only when there is a non-zero value on cell - please help

Windows 8

Office 2013

Novice

Join Date: Nov 2014

Posts: 6

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Cell Background Color: Base it on Content of Cell?	tatihulot	Excel	4	08-14-2013 03:24 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 PM.