|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?