Count IF
 

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.

Count IF
 

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



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

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

HTH

"carl" wrote:

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.