I'm trying to average multiple cells, but I need the formula to not include null or 0 values into the average calculation. The tricky part though, is that the fields that need to be averaged are sparsely populated in a worksheet and are not in a single range.
For example, I need to average cells F7, H7, J7, M7, P7, V7. None of these cells are in a single range, and some of them will be 0's that I'll need to have excluded from the calculation.
Bookmarks