統計金額 依地名與月份 空白同上日期 (14896)

G2:I6=SUMPRODUCT((LOOKUP(ROW(2:30),ROW(2:30)/($A$2:$A$30>0),$B$2:$B$30)=$F2)*(TEXT(LOOKUP(ROW(2:30),ROW(2:30)/($A$2:$A$30>0),$A$2:$A$30),"M月")=G$1)*$D$2:$D$30)