條件1:
=SUM(IFERROR(FIND(B2:B999,"#ZOR1#ZOR3#ZOR7#ZORE#")^0,)*(D2:D999="安得")*(E2:E999="江津")*((F2:F999="已签收")+(F2:F999="换货已交接")))
條件2:
=SUM(IFERROR(FIND(B2:B999,"#ZOR1#ZOR3#ZOR7#ZORE#")^0,)*(D2:D999="安得")*(E2:E999="江津")*((F2:F999="已签收")+(F2:F999="换货已交接"))*(M2:M999-H2:H999<=1))
祝順心,南無阿彌陀佛!