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.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 ?
or whats formula of "if" or "round", if I want to know the count from that value of 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?
I'm already try =COUNTIF(A2:A22,ROUND(MODE(A2:A22),1)) , but the result = 1 not 6. anybody can help me?
Aucun commentaire:
Enregistrer un commentaire