=COUNTIFS(Sheet1!S2:S9441,"=Approved",Sheet1!T2:T9441,"=Apparel, Accessories & Bags")
如果条件区域没有等于号“=”，那么修改为
=COUNTIFS(Sheet1!S2:S9441,"Approved",Sheet1!T2:T9441,"Apparel, Accessories & Bags")
或者直接
=COUNTIFS(Sheet1!S:S,"Approved",Sheet1!T:T,"Apparel, Accessories & Bags")
