統計一周 多維數字 (14376)

(樓層要一致 用英文)C16:G16 下拉{=SUM(OFFSET($A$3,,MATCH($A16,$2:$2,)-5,10,5)*(IF($B$3:$B$12=0,$B$2:$B$11,$B$3:$B$12)=C$15)*(LOOKUP(1,0/($C$14:C$14<>""),$C$14:C$14)=$C$3:$C$12))

H16=SUM(C16:G16)

C16:G16 複製到16:16下拉