1y column – a list with repeating values ​​(text).

2nd column – values ​​(numbers).

3d column – desired values.

Is it possible to make the formula to calculate the number of cells of non-equal 0 from the second column for each value from the first column?

There are silent, but values ​​will be summed up, and you just need count.
https://yadi.sk/i/7ksys2fjrer75a

aaa 0 1
AAA 4 1.
Aaa 0 1.
BBB 0 0.
BBB 0 0.
CSS 0 3.
CSS 1 3.
CSS 3 3.
CSS 0 3.
CSS 1 3.

Answer 1, Authority 100%

cx = countable ($ a $ y: $ A $ z; ax; $ b $ y: $ b $ z; "& lt; & gt; 0")

where:

• x – current line
• y, z – the initial and final lines of the data table

In principle, if there is nothing on top-bottom, it is possible and just

cx = countable ($ A: $ a; ax; $ b: $ b; "& lt; & gt; 0")

Answer 2

as option

= sample (- ($ A $ 2: $ A $ 99 = A2); - ($ b $ 2: $ b $ 99 & lt; & gt; 0))

sometimes saves, but for this task it is better to apply 8