季度與年度 統計 (12634)

B5:E5=SUM(OFFSET($A2,,MATCH(B4,1:1,)-1,,-3))

B5:E5另解=SUM(OFFSET($B2,,COLUMN(A1)*3-3,,3))

B5:E5另解=NPV(-2,SUMIF($B$1:$Q$1,"<="&EOMONTH(B4,{-3,0}),$B$2:$Q$2))

B7:C7=SUMPRODUCT((YEAR(B1:Q1)=B6)*B2:Q2)

B7:C7另解=NPV(-2,SUMIF($B$1:$Q$1,"<="&EOMONTH(B6&"-12-1",{-12,0}),$B$2:$Q$2))