如何使用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屋！