averaging with missing values

Create your own "averageif()" function with a formula:

SUMIF() / COUNTIF()