Ask Your Question

Revision history [back]

Another possiblity, that does not use a matrix formula is simply using "<>#N/A" as the if-condition.

=AVERAGEIF(O2:O124;"<>#N/A")
=SUMIF(O2:O124;"<>#N/A")