How to count how many times in a given column (Google Excel) the desired word occurs?

Question

Google

There is such a Google Excel file:
https://docs.google.com/spreadsheet/ccc?key=0ApUv4...
If you look into cells B4 or B5 in it, you can see that they contain the word "Professional".
Moreover, this word is located among other words, separated by commas.
And in some cells of column B, this word is completely absent.
How can you count how many times the word "Professional" occurs in column B, and then display this number in a separate cell?
In fact, I already have it implemented using the code:

=SUM(COUNTIF(B:B;{"Профессионал";"Начинающий, Профессионал";"Продвинутый, Профессионал";"Начинающий, Продвинутый, Профессионал"}))

and everything works fine. But only this method has too cumbersome notation (if there are not 3 values, but 5 or more, then the expression will turn out to be very large).
Therefore, I would like to find another way.
In general, you can probably use something like this (but this is not yet a fully working construction): And then sum the values ​​​​for all cells in column B. But I don’t know how yet.
=IF(ISNUMBER(SEARCH("Профессионал";B5));"1"; "0")

Answer 1

=COUNTIF(B:B;"*рофессионал*")