[Solved] Counting column with "NO$"

[Cat101]

I have a simple spreadsheet with 8 codes, like W, SM, M, etc but one is "NO$"

Im just trying to do a simple count of each code using =COUNTIF(Jan_Freq;"=W")
Which works for all the codes but "NO$"

I've read thru several of the tutorials looking for an answer.
I even tried to reformat the column to text, but still no work.. grrrr

This is a sheet that they have used for years, so no chance of changing their processes.

Im sure I could make some formula to count if <> to the others, then it must be NO$, but yuck..
I try to apply the KISS principle, for anyone who may work on it later..

And yes, I've suggested Libre to them, but no change..

Any suggestions or Direction?

[FJCC]

Here are two possible solutions.
1. Search from "NO\$"
2. Go to the menu Tools -> Options, expand the OpenOffice Calc list on the left, select Calculate, turn off the option Enable Regular Expressions in Formulas. You should then be able to search for "NO$".

The $ character has a special meaning in regular expressions. You either have to disable regular expression as in item 2, or put a \ before the $ to signal that you want a literal $, not the special meaning.

[Cat101]

THANKS.... will try tomorrow! & update if solved..

[Cat101]

Oh FJCC thanks!! the NO\$ worked!!