I am attempting to use the AVERAGEIFS function in Excel 2007. The other two criteria and criteria range I am using in the function work very well. Now I am trying to add a third criteria where any averaged cell with a #N/A error is not attempted to be averaged. Right now, it is trying to average a range of cells that may contain an #N/A error. I would like to figure out how I can use the AverageIfs function and a specific criteria to have it not average any cells that contain the error but will still average all the other cells in the range that actually contain a number. Right now, the AverageIfs function just returns an #N/A error if any of the averaged cells contain an #N/A.
The reason my averaged range contains errors (#N/A) is because I am charting that range and do not want the error data to be shown on the chart.
The reason my averaged range contains errors (#N/A) is because I am charting that range and do not want the error data to be shown on the chart.