I am aware that the Average function does not include blank cells in the calculation, this is not my question.
I would like to take an average of a row of 4 cells and copy the formula down a LARGE spreadsheet. There are some rows were only 1 or 2 out of the 4 contain any values and I would NOT like to return an average for any of these rows.
Please help me all you Excel geniuses out there.
Many thanks
Bookmarks