I think I would assign each of the monthly amounts to an array. Then use the current month to get the index of the proper element in the array and add up the following two months to it. Then divide by three. The tricky part will be at the end of the year where you have to add logic so that the summary amount starts back at the beginning of the year for however many remaining months there are in the formula.
I have extensive coverage of arrays and creating formulas in chapters 5-7 in my Encyclopedia book. You can click on the banner below to find out more information.
IP Logged
