Sheet2的B2单元格写公式：
=COUNTIFS(Sheet1!F:F,A$1,Sheet1!E:E,A$2)
Sheet2的B3单元格写公式：
=COUNTIFS(Sheet1!F:F,A$1,Sheet1!E:E,"")
Sheet2的B4单元格写公式：
=COUNTIF(Sheet1!F:F,A$1)-B2-B3
b2=countifs(sheet1!f:f,"在库”,sheet1!e:e,a2)
b3=countifs(sheet1!f:f,"在库”,sheet1!e:e,"=")
b4=countifs(sheet1!f:f,"在库”,sheet1!e:e,"<>",sheet1!e:e,"<>展厅”)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024