Average of a selected range

Copper Contributor



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).2023-12-08_14-56-26.png


Is this possible?

2 Replies


Perhaps this one:





With the help of TOROW you can ignore errors.