在Sheet2表中有一行统计
=SUMPRODUCT((INDIRECT("Sheet1!A3:A"&LOOKUP(1,0/(Sheet1!A:A<>""),ROW(Sheet1!A:A)))>=$D$1)*(INDIRECT("Sheet1!A3:A"&LOOKUP(1,0/(Sheet1!A:A<>""),ROW(Sheet1!A:A)))<=$G$1)*(INDIRECT("Sheet1!B3:B"&LOOKUP(1,0/(Sheet1!A:A<>""),ROW(Sheet1!A:A)))=B2))
如何让"Sheet1!B3:B"中的B随着向右填充而自改改成C、D、E、……？

目测是会自动变的啊

INDIRECT("Sheet1!B3:B"&LOOKUP(1,0/(Sheet1!A:A<>""),ROW(Sheet1!A:A)))
改为
OFFSET(Sheet1!B3,,,LOOKUP(1,0/(Sheet1!$A$1:$A$10000<>""),ROW(Sheet1!$A$1:$A$10000))-2)
其他的Sheet1!A:A可能也得改下吧？

让"Sheet1!B3:B"中的两个B随着向右填充而自动改成C、D、E、……

将....INDIRECT("Sheet1!B3:B"&....
改为....INDIRECT("Sheet1!"&CHAR(COLUMN(BN1))&"3:"&CHAR(COLUMN(BN1))&....