title: How to use countif and if and round in the same time
body: <p><a href="https://drive.google.com/file/d/0Bzo6AOJw3kkBMnlzZDJTSHdLOEU/view?usp=sharing" rel="nofollow"><img src="https://lh3.googleusercontent.com/GNWbqt4yAmyW5F8V-Ie8cddXZUVnIaULg_DAqaeFxGGh7h0bks0gYGmmDPgn6oyfcW5BrDvJOWkel3I=w1580-h934-rw" alt="Image"></a></p>
  
  <p>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 ?</p>
  
  <p>the question is , how to let the count ​​of the formula may appear with the known just mode ?</p>
  
  <p>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?</p>
  
  <p>I'm already try =COUNTIF(A2:A22,ROUND(MODE(A2:A22),1)) , but the result = 1 not 6. anybody can help me?</p>