Try...

C1, copied down:

=SUMPRODUCT(--($A$1:$A$4=A1),--($B$1:$B$4=""))

Hope this helps!

In article ,
Wingman wrote:

Looking for a function to count the number of similar cells(Col A), but not
count them if the adjacent cell(Col B) has any text/numbers in it.

Col A Col B Col C
text1 2
text2 11/2 1
text1 2
text2 1

I log in tickets and need to know how many have not been paid.