How to display the number of matches in a row in a table in excel?

Question

excel

There is a large table with information about the goods. And there is, for example, a list of brands: xiomi, samsung and others.
How can I show "the number of products found 94" in front of xiomi?

Answer 1

Use COUNTIF (COUNTING in Russian, probably).
If you need to count by substring, add * to the condition.
Something like this:

Where the first argument is the range where we count, the second - what we count.