如果你用的是2007及以上的版本
则公式为
=COUNTIFS(A:A,"1小组",B:B,"语文",C:C,">=90",C:C,"<=95")
如果用的是2003版
则要假设数据有1000行,公式为
=SUMPRODUCT((A1:A1000="1小组")*(B1:B1000="语文")*(C1:C1000>=90)*(C1:C1000<=95))
=SUMPRODUCT(($A$1:$A$100="1小组")*($B$1:$B$100="语文")*($C$1:$C$100>=90)*($C$1:$C$100<=95)*$C$1:$C$100)
=sumproduct((A1:A100="1小组")*(b1:b100="语文")*(c1:c100>=90)*(c1:c100<=95))
=SUMPRODUCT(($A$2:$A$999=“1小组”)*($B$2:$B$999=“语文”)”($C$2:$C$999=<95)*($C$2:$C$999=<90))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024