如何使用Countif以及If和Round同时进行 [英] How to use countif and if and round in the same time
问题描述
值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屋!