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.