I apologise in advance as I have seen multiple responses to using this formula but none are working for me in a very simple scenario.
I have a short column of figures, but one cell in the column could be blank, it has a simple formula in the blank cell, like =SUM(H45/F45) that can't be completed because one of the cells F45 is blank. So the cell where this formula is, is blank At the end of the column, I have =AVERAGE (J38:J45) for example.
The problem is it does not average the existing or showing figures and still divides the total of the column by every cell including the blank cell, thus giving me an incorrect average of the figures in the column.
I hope this is clear enough for someone to provide a solution and thanks in advance if you can.