周別與數值 統計出現次數 (13296)

E3:I7=SUMPRODUCT((INT((DAY($A$2:$A$99)-1)/7)+1=$D3)*($B$2:$B$99=E$2)*(YEAR($A$2:$A$99)=$K$3)*(MONTH($A$2:$A$99)=$K$6))



留言