如何使用Countif以及If和Round同时进行 [英] How to use countif and if and round in the same time

查看:294
本文介绍了如何使用Countif以及If和Round同时进行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

值3.14 =值3.1吧?
,而值3.1不仅​​是3.14,还包括3.05、3.06、3.07、3.08、3.09、3.10、3.11、3.12、3.13和3.14,对吗?

From this picture we know the data have mode 3.14 and the value 3.14 = value 3.1 , right? whereas the value 3.1 its not only 3.14 , but include 3.05, 3.06, 3.07, 3.08, 3.09, 3.10 , 3.11 , 3.12 , 3.13 , and 3.14 right ?

问题是,如何让公式的计数以已知的正义模式出现?

the question is , how to let the count ​​of the formula may appear with the known just mode ?

或 if或 round的公式是什么,如果我想从数据范围中选择3.05、3.06、3.07、3.08、3.09、3.10、3.11、3.12、3.13和3.14的值,而不必减少数据列中的小数点并且没有键入值?

or whats formula of "if" or "round", if I want to know the count from that value of 3.05, 3.06, 3.07, 3.08, 3.09, 3.10 , 3.11 , 3.12 , 3.13 , and 3.14 was selected from the range of data without having to reduce the decimal point in the data column and without typing the value?

我已经尝试过= COUNTIF(A2:A22,ROUND(MODE(A2:A22),1)),但结果= 1不是6。有人可以帮助我吗?

I'm already try =COUNTIF(A2:A22,ROUND(MODE(A2:A22),1)) , but the result = 1 not 6. anybody can help me?

推荐答案

=COUNTIF(A2:A22,"<="&3.14)-COUNTIF(A2:A22,"<"&3.05)

计算等于或小于3.14的所有内容,然后减去小于3.10的所有内容。

count everything equal to or below 3.14, and then subtract everything less than 3.10.

要使舍入过程自动化,您可以采用Dirk提出的建议

To automate the rounding process, you could go with what Dirk was suggesting and use:

=COUNTIF(A2:A22,"<"&ROUND(MODE(A2:A22),1)+0.05)-COUNTIF(A2:A22,"<"&ROUND(MODE(A2:A22),1)-0.05)

概念证明

这篇关于如何使用Countif以及If和Round同时进行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆