The simplest way to find the average (mean) of a set of numbers is to use the AVERAGE function. This calculation gives you the arithmetic mean, which sums up all the numbers and divides the result by ...
Averaging is easy until you want to dynamically average the last few years on the fly. There are at least two easy ways to accommodate the n requirement. Averaging is easy business in Microsoft Excel.