I need to average an array of cells and I need the blank ones to have a value of ZERO in order for my average to be accurate. Right now, blank cells aren't contributing to the average. I don't want to have to populate all the empty cells with a 0 entry.

E.g. If one cell value is 8 and I need to calculate the avg across 2 cell values, I want the answer to be 4, but it's returning 8 as the average because the 2nd cell is blank.

In reality, I'm after the average of a larger array of cells, some may be filled and some may be empty, but I need the empty ones to count.