統計当天前後數 三維 (9590)

B2:C4=SUMPRODUCT(N(OFFSET($A8,{0;4;8},COLUMN($A:$AE)))*ABS((N(OFFSET($A$7,{0;4;8},COLUMN($A:$AE)))<=$O$2)-(B$1=$C$1))*(N(OFFSET($A$7,{0;4;8},COLUMN($A:$AE)))>0))

另解=SUMPRODUCT((MOD(ROW($1:$9),4)=1)*ABS(($B$7:$AF$15<=$O$2)-(B$1=$C$1))*$B8:$AF16)