Excel cell formula to disregard empty cell

Microsoft Microsoft excel 2007 full vers...
January 20, 2011 at 02:20:53
Specs: Windows Vista
I need to show the sum total of 2 cells. The top cell will always have a value. The bottom cell will not always have a value.

I want the target (sum) cell value to show only when the bottom cell has a value zero or upwards. If the bottom cell is blank I don't want a sum total to show.

In other words I don't want the blank cell to be recognised as zero value until a zero or other number is actually entered in to the cell.

I hope you can figure out what the heck I'm talking about. If so, can you help?

Thanks
Jim


See More: Excel cell formula to disregard empty cell

Report •

#1
January 20, 2011 at 04:27:19
=IF(A2="", "", SUM(A1:A2))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 20, 2011 at 06:04:42
Thanks for that. However I can't get it to work. Perhaps I should have mentioned that I am subtracting the bottom cell value from the top cell. Don't know if that affects it. Based on your suggestion my cell formula actually looks like
=IF(E6="", "", SUM(E5-E6))
but unfortunately this doesn't work.

Any other suggestions?

Thanks Jim


Report •

#3
January 20, 2011 at 12:55:57
I'm confused.

Please post actual examples of your data and the desired output based on those examples. Include the Column letters and Row numbers for your data and for the cell where you want this formula to reside. This will help keep the confusion to a minimum.

Please read the How To reference in the following line before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question