Actually, it is still true.That is not true if all cells are blank in range.
That is not true if all cells are blank in range.
I have a range of cells used for Status averages. Initially each week all cells are blank and then filled in as tasks are completed or partially.
I want an average of all non-blank cells at the top but using any of the formulas given here, there is an error when all cells are blank. Any input?