Count IF

[Guest]

My Data Table looks like this:

Spy 0
Goog 2
IBM 1
IBM 1


I am looking for a formula for B1,2,3 that will look at my data table, for
each name in my new table, count the number of non-zero cells in colb of the
data table. Sort of like this table:

Spy 0
Goog 1
IBM 2


Thank you in advance.

 

[Guest]

A B
Spy 0 <=== Row 8
Goog 1
IBM 2



=SUMPRODUCT(--($A$1:$A$4=A8),--($B$1:$B$4>0))

A8="Spy", A9="Goog" etc

HTH