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

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

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.

Ask Your Question

Weekly Poll