In Microsoft Excel (part of the Microsoft Office productivity suite), you can count the number of times a string (a piece of text) appears in a range of cells.
Let’s take the following table as an example:
| Option A | Option B | Option C | Totals |
| X | X | 2 | |
| X | 1 | ||
| X | X | X | 3 |
To get the totals automatically (in other words: how many times does ‘X’ appear in this row?), use the following formula:
=COUNTIF(E4:H4,"X")
The formula says: if in range E4 to H4 the value ‘X’ appears, count this and output the total.
However, upon entering this formula, I received an error prompt telling me:
The formula you typed contains an error.
For information about fixing common formula problems, click help.
To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group).
If you are not trying ot enter a formulam avoid using an equal sign (=) or minus sign (-) or precede it with a single quotation mark (‘).
So the COUNTIF function is not working? And this error message wasn’t all too helpful either. Luckily, I tried other notations and finally found an answer. I had to replace the comma (,) with a semicolon (;).
The COUNTIF formula now becomes a working one:
=COUNTIF(E4:H4;"X")
What’s wrong with this formula?
=AND(FIND(“@”,K1),FIND(“.”,K1),ISERROR(FIND(” “,K1),ISERROR(FIND(“,”,K1))))
Thanks a lot, i got it.
Thank you so much even Microsoft is giving the wrong answers!
thankyou very much, you save my life