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 range from 0-3 but N/A is a possibility as well. This is a live worksheet that is populated from a Google Form. I keep getting the #DIV/0! error when I try to create the average. The equation I am using is =AVERAGE (M2:AQ2).

Is this possible?