I perform a lookup where the results could populate one cell or as many as 15
cells with number results. The cells that do not result in numbers have
#N/A. I want to average the fifteen cells but only the cells with numbers.
How do I get it to ignore the #N/A when performing the average?