excel中sheet2中某一单元格等于sheet1中C列是Y的前提下D2:D7的和
excel中sheet2中某一单元格等于sheet1中C列是Y的前提下D2:D7的和
日期：2022-02-14 07:51:23 人气：1
在sheet2的c1写公式:
=SUMPRODUCT((OFFSET(SHEET1!$A$2,6*INT((ROW($1:$100)-1)/6),)=$B1)*(SHEET1!$B$2:$B$101="a")*(SHEET1!$C$2:$C$101="Y")*(SHEET1!$D$1:$H$1=LOOKUP(1,0/($A$1:$A1<>&qu
=SUMPRODUCT((OFFSET(SHEET1!$A$2,6*INT((ROW($1:$100)-1)/6),)=$B1)*(SHEET1!$B$2:$B$101="a")*(SHEET1!$C$2:$C$101="Y")*(SHEET1!$D$1:$H$1=LOOKUP(1,0/($A$1:$A1<>&qu