Average cells including blank cells

The AVERAGE and AVERAGEA functions will always exclude blank cells

'=SUM(D2:D5)/ROWS(D2:D5)
'=SUM(D2:D5)/(COUNT(D2:D5)+COUNTBLANK(D2:D5))

Related Formulas

Average cells that are numbers
Average cells that are numbers ignoring zeros
Average cells that are numbers using weighted average