總和 多條件 (9310)

 

  K2=SUMPRODUCT((A2:A7>=H2)*(A2:A7<=I2)*(B2:B7=J2)*(C1:E1=K1)*C2:E7)

另解{=SUM(HLOOKUP(K1,C:E,ROW(2:7),)*(A2:A7>=H2)*(A2:A7<=I2)*(B2:B7=J2))

另解SUMIFS(INDEX(A:E,,MATCH(K1,1:1,)),A:A,">="&H2,A:A,"<="&I2,B:B,J2)