excel同時滿足兩個條件:excel滿足2個條件取值[朗讀]

假設兩個表的表名分別為sheet1、sheet2在sheet1的b2輸入公式=sumproduct((day(sheet2!$a$3:$a$100)=$a2)*(sheet2!$d$3:$d$100=b$1)*sheet2!$g$3:$g$100)右拉至c2,再下拉在sheet1的d2輸入公式=sumproduct((day(sheet2!$a$3:$a$100)=$a2)*(sheet2!$d$3:$d$100=d$1)*sheet2!$f$3:$f$100)右拉至g2,再下拉即可。