EXCEL中,要统计一列数据中大于或等于某个单元格乘以百分数的个数如C59要显示出在C3——C52中大于等于C53乘以60%的个数,
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 21:22:40
![EXCEL中,要统计一列数据中大于或等于某个单元格乘以百分数的个数如C59要显示出在C3——C52中大于等于C53乘以60%的个数,](/uploads/image/z/3179946-66-6.jpg?t=EXCEL%E4%B8%AD%2C%E8%A6%81%E7%BB%9F%E8%AE%A1%E4%B8%80%E5%88%97%E6%95%B0%E6%8D%AE%E4%B8%AD%E5%A4%A7%E4%BA%8E%E6%88%96%E7%AD%89%E4%BA%8E%E6%9F%90%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC%E4%B9%98%E4%BB%A5%E7%99%BE%E5%88%86%E6%95%B0%E7%9A%84%E4%B8%AA%E6%95%B0%E5%A6%82C59%E8%A6%81%E6%98%BE%E7%A4%BA%E5%87%BA%E5%9C%A8C3%E2%80%94%E2%80%94C52%E4%B8%AD%E5%A4%A7%E4%BA%8E%E7%AD%89%E4%BA%8EC53%E4%B9%98%E4%BB%A560%25%E7%9A%84%E4%B8%AA%E6%95%B0%2C)
x)spvycewn
O;?Y:%˟{1Nc';V=ق=Ovx{v<2.kr6lƾKv=mt
gG
Sn0TgScIfp3tli@q~H[gPO7
gc+F%;[%5z-=3M<;_ PB
EXCEL中,要统计一列数据中大于或等于某个单元格乘以百分数的个数如C59要显示出在C3——C52中大于等于C53乘以60%的个数,
EXCEL中,要统计一列数据中大于或等于某个单元格乘以百分数的个数
如C59要显示出在C3——C52中大于等于C53乘以60%的个数,
EXCEL中,要统计一列数据中大于或等于某个单元格乘以百分数的个数如C59要显示出在C3——C52中大于等于C53乘以60%的个数,
=COUNTIF(C3:C52,">="&C53*0.6)