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,再下拉即可。