2

I am trying to count the total cells that have a single decimal value.

For example:

1.1 (1)
2
1.2 (2)
3.333
1.3 (3)
4
1.4 (4)
5.55555
1.5 (5)
6
1.6 (6)
1.7777777
1.7 (7)
8
1.8 (8)
9.999999999
1.9 (9)

What formula should be used to attain a total of nine?

1
  • 1
    Have you tried the given solutions? Did any work for you? If yes, as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well. Feb 2, 2021 at 15:27

1 Answer 1

1

You can use the following

=ArrayFormula(COUNTIF(LEN(INDEX(SPLIT(A2:A,"."),,2)),"=1"))

COUNTIF only one decimal digit in range

Functions used:

2
  • 1
    You can reduce that to =COUNTIF(A2:A,"*.*")
    – Jacob Jan
    Feb 2, 2021 at 8:10
  • 1
    @JacobJanTuinstra I believe the OP used the (1) etc. as a guide to just show which values to count. Feb 2, 2021 at 8:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.