Good afternoon,

Alright, here's a simple one. How I have forgotten it (when I use it almost every day) is beyond me. All I know is that my mind is mush right now.

I am preparing a blank work sheet for others to use, so here it is:

I have multiple columns that all sum different cells. I need the "Answer" cell to not show a 0 if there is nothing to "sum".

ex. Cell A1 is the sum total of A2-A10. If A2-A10 are empty, I do NOT want A1 to show 0.

I have no idea how I am forgetting this today. I need a drink.

Thanks for your help. Really.