L3：=SUM(COUNTIFS(B:B,{"*河南*","*湖北*","*安徽*"},C:C,"Z*")
)M3：=SUM(SUMIFS(F:F,B:B,{"*河南*","*湖北*","*安徽*"},C:C,"Z*"))
283
2024-04-08 23:51
admin