Average of a selected range

Hello,   I am trying to average a selected range but have the function ignore any cells that have "N/A" in them. For example, I would like to average cells M2 - AQ2 in my worksheet. The numbers ran...