I got a column with several rows containing m or w.
So I just want to count how many of that rows contain the letter w. This looks like a rather simple task but excel is throwing an error on me when I use the function like this:
=COUNTIF(C2:C123, "w")
There`s a problem with this forlmula When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula
I looked at the documentation of the formula:
It seems that I'm doing nothing wrong here. What is causing this type of error?
2 Answers
It appears microsoft decided that parameters are not longer seperated by using , instead I have to use ;.
I haven't noticed that because I'm not using excel very often, but it seemed to be faster than writing a script for that task.
1Not posting as a solution necessarily, but posting a noteworthy observation:
The formula does in fact use a comma and not a semicolon. Semicolons I generally see in programming languages to indicate an "end of line" or "end of sentence".
1
