F5=SUMIFS(C$2:C$16,B$2:B$16,">="&EOMONTH(F$2,-1)+1,B$2:B$16,"<="&EOMONTH(F$2,0))
F6=SUMIFS(C$2:C$16,B$2:B$16,">="&DATE(YEAR(F$2),INT((MONTH(F$2)-1)/3)*3+1,1),B$2:B$16,"<="&EOMONTH(DATE(YEAR(F$2),INT((MONTH(F$2)+2)/3)*3,1),0))
一式公式 F9:F10{=SUM((IFERROR(LOOKUP(B$2:B$16,IF(ROW(A1)=1,EOMONTH(F$2,{-1,0})+1,DATE(YEAR(F$2),INT((MONTH(F$2)-1)/3)*3+{1,4},1))),)=IF(ROW(A1)=1,EOMONTH(F$2,-1)+1,DATE(YEAR(F$2),INT((MONTH(F$2)-1)/3)*3+1,1)))*C$2:C$16)
留言
張貼留言