Hello,

I hope you might be able to help me with a little glitch or misconception of IFCOUNT.

I’m trying to count cells containing version numbers formated as text, like 2.2, 2.3, 2.3.4.

I used =COUNTIF(range; “2.2”), =COUNTIF(range;B1) - B1 containing “2.2” and =COUNTIF(range;&B1) - formating B1, containing “2.2”, to text.

Nothing worked so far. I get an empty cell instead of a result number of at least 1 or 0 or just the formular in the cell.

Any ideas what I’m doing wrong? Thanks in advance for your help.