- b4=INDIRECT(YEAR(G2)&"年!r2c"&MONTH(G2)+1,)
- c4=INDIRECT(YEAR(EDATE(G2,-1))&"年!r2c"&MONTH(EDATE(G2,-1))+1,)
- d4=INDIRECT(YEAR(G2)-1&"年!r2c"&MONTH(G2)+1,)
- e4=SUM(OFFSET(INDIRECT(YEAR(G2)&"年!r2c"&LOOKUP(MONTH(G2),{1;4;7;10}),),,1,,3))
- f4=SUM(OFFSET(INDIRECT(YEAR(EDATE(G2,-3))&"年!r2c"&LOOKUP(MONTH(EDATE(G2,-3)),{1;4;7;10}),),,1,,3))
- g4=SUM(OFFSET(INDIRECT(YEAR(EDATE(G2,-15))&"年!r2c"&LOOKUP(MONTH(EDATE(G2,-15)),{1;4;7;10}),),,1,,3))
- h4=SUM(OFFSET(INDIRECT(YEAR(G2)&"年!r2c"&MONTH(G2)+1,),,,,-MONTH(G2)))
- i4=SUM(OFFSET(INDIRECT(YEAR(G2)-1&"年!r2c"&MONTH(G2)+1,),,,,-MONTH(G2)))
复制代码 |