I am building a country ranking model spreadsheet. As part of this project, I am ranking several different macroeconomic indicators and then creating a column which provides an average of each of these ranks. As some countries contain n.a. values for some macroeconomic indicators, i would love to embed in the average formula some kind of function which would automatically return an n.a. value if more than half of the ranked macroeconomic indicators have n.a. values in the column. I would be extremely grateful if anyone knows a formula that would work for this.

Thanks for your help.

David