thanks! I forgot to post this as solved. I got it last night with this:

=IF(AND(G4="N/A",K4="N/A",O4="N/A"),"N/A",SUM(IF(G4="N/A",0,G4),IF(K4="N/A",0,K4),IF(O4="N/A",0,O4))/SUM(IF(G4="N/A",0,1),IF(K4="N/A",0,1),IF(O4="N/A",0,1)))

Which also solves for the issue if the denominator is zero.

Happy New Year!!