=IERROR(expression, "")

The result is not a blank cell (it's a formula that returns a null string), but it's ignored by AVERAGE.