=sumproduct((sheet1!a$2:a$60000=a2)*(year(sheet1!b$2:b$60000)=b2)*(sheet1!c$2:c$6000)) 这下可以下拉了
=sumproduct((sheet1!a2:a100=a2)*(year(sheet1!b2:b100)=b2)*(sheet1!c2:c100))
