Untested

=sumproduct(c1:c500)<>#N/A)/countif(c1:c500,"<>#N/A")