excel中如何分段求平均值?=AVERAGE(D2:D366)=AVERAGE(D367:D732)=AVERAGE(D733:D1097)=AVERAGE(D1098:D1462)=AVERAGE(D1463:D1827)=AVERAGE(D1828:D2193)=AVERAGE(D2194:D2558)=AVERAGE(D2559:D2923)=AVERAGE(D2924:D3288)=AVERAGE(D3289:D3654)=AVERAGE(D3655

excel中如何分段求平均值?=AVERAGE(D2:D366)=AVERAGE(D367:D732)=AVERAGE(D733:D1097)=AVERAGE(D1098:D1462)=AVERAGE(D1463:D1827)=AVERAGE(D1828:D2193)=AVERAGE(D2194:D2558)=AVERAGE(D2559:D2923)=AVERAGE(D2924:D3288)=AVERAGE(D3289:D3654)=AVERAGE(D3655
excel中如何分段求平均值?
=AVERAGE(D2:D366)
=AVERAGE(D367:D732)
=AVERAGE(D733:D1097)
=AVERAGE(D1098:D1462)
=AVERAGE(D1463:D1827)
=AVERAGE(D1828:D2193)
=AVERAGE(D2194:D2558)
=AVERAGE(D2559:D2923)
=AVERAGE(D2924:D3288)
=AVERAGE(D3289:D3654)
=AVERAGE(D3655:D4019)
=AVERAGE(D4020:D4384)
=AVERAGE(D4385:D4749)
=AVERAGE(D4750:D5115)
=AVERAGE(D5116:D5480)
=AVERAGE(D5481:D5845)
=AVERAGE(D5846:D6210)
=AVERAGE(D6211:D6576)
=AVERAGE(D6577:D6941)
=AVERAGE(D6942:D7306)
=AVERAGE(D7307:D7671)
=AVERAGE(D7672:D8037)
=AVERAGE(D8038:D8402)
=AVERAGE(D8403:D8767)
=AVERAGE(D8768:D9132)
=AVERAGE(D9133:D9498)
=AVERAGE(D9499:D9863)
=AVERAGE(D9864:D10228)
=AVERAGE(D10229:D10593)
=AVERAGE(D10594:D10959)
如何一次插入到这列后面?

excel中如何分段求平均值?=AVERAGE(D2:D366)=AVERAGE(D367:D732)=AVERAGE(D733:D1097)=AVERAGE(D1098:D1462)=AVERAGE(D1463:D1827)=AVERAGE(D1828:D2193)=AVERAGE(D2194:D2558)=AVERAGE(D2559:D2923)=AVERAGE(D2924:D3288)=AVERAGE(D3289:D3654)=AVERAGE(D3655
假设公式从E2开始,则在E2输入
=AVERAGE(INDIRECT("d"&ROW()*365-728):INDIRECT("d"&ROW()*365-364))
下拉复制公式即可
注意,你给出的公式好像有点问题,我这个是等距365行求平均值