Hi. I have a question about how to do something I'm guessing is very simple, but elusive to me nonetheless. I want to print the sum of the data in a range of cells (say F2:F4) in another cell (say F5), but I only want to do that if there is data in one of the cells that I'm summing.
I can get it to print the sum, but if they the cells I'm summing are blank, I don't want to print anything in the target cell. I've tried various things, but I always get a 0 to print if the cells are blank. Anyone know what I should do to get it do print nothing in that cell? The 0 is messing up a graph that is tied to the data.
Any help is MUCH appreciated!
Bookmarks