Hi!

I have a chart with percentages that I want to average. However, I use #N/A formula on the cells that don't have values (so the graph doesn't get messed up). How can I make the AVERAGE() formula ignore the #N/A values so I can get the proper average?

Thanks in advance!