第1个回答 2022-02-27
=SUMPRODUCT((LEFT(A1:A100,3)="SL-")*(C1:C100>=DATE(2022,1,2))*(C1:C100<=DATE(2022,1,6))*B1:B100)
=SUMPRODUCT((LEFT(A1:A100,3)="BL-")*(C1:C100>=DATE(2022,1,2))*(C1:C100<=DATE(2022,1,6))*B1:B100)
=SUMPRODUCT((LEFT(A1:A100,2)="D-")*(C1:C100>=DATE(2022,1,2))*(C1:C100<=DATE(2022,1,6))*B1:B100)