I would like to change the month in a specific cell every month and have the formula average the month after through Dec. automatically. I wrote the below formula which is not working. For example below I would like the average of June through December by asking it to take May + 1 Does anyone have any thoughts on how I could modify?
<tbody>
</tbody>
May | Jun - Dec 2018 Avg | January | February | March | April | May | June | July | August | September | October | November | December |
=AVERAGEIF(C1:N1,">A1",C2:N2) | 773 | 874 | 877 | 852 | 991 | 946 | 880 | 1,012 | 924 | 1,009 | 1,058 | 961 |
<tbody>
</tbody>