EXCEL 计算一组数据的合格率NO.上公差下公差 10.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 02:24:40
![EXCEL 计算一组数据的合格率NO.上公差下公差 10.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0](/uploads/image/z/3928359-39-9.jpg?t=EXCEL+%E8%AE%A1%E7%AE%97%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E5%90%88%E6%A0%BC%E7%8E%87NO.%E4%B8%8A%E5%85%AC%E5%B7%AE%E4%B8%8B%E5%85%AC%E5%B7%AE%E3%80%80%E3%80%80%E3%80%8010.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0)
EXCEL 计算一组数据的合格率NO.上公差下公差 10.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0
EXCEL 计算一组数据的合格率
NO.上公差下公差 10.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0.3-0.2-0.1120.4-0.40.10-0.2130.6-0.6000.1140.4-0.4000.1
需要在黄色位置算出这一列的合格率,C2
EXCEL 计算一组数据的合格率NO.上公差下公差 10.5-0.5-0.10020.5-0.50.10030.5-0.5-0.3-0.2-0.240.5-0.50.10.10.150.5-0.500.1060.5-0.5-0.4-0.4-0.470.8-0.800.1-0.180.75-0.75-0.1-0.1-0.190.8-0.80.50.60.5100.8-0.8-0.1-0.3-0.2110.6-0.6-0
D2输入公式:
=SUMPRODUCT((C3:D16=$C3:$C16))/COUNT(D3:D16)
右拉填充即可