Another possiblity, that does not use a matrix formula is simply using "<>#N/A" as the if-condition.
=AVERAGEIF(O2:O124;"<>#N/A")