On Feb 20, 9:54*pm, yshridhar
wrote:
If the data is inthe range a1:a10
=countif(a1:a10,a1)
with regards
Sreedhar

He could however, use a COUNT(IF similar to my SUM(IF suggestion by
entering:
=COUNT(IF((A1:A9="Muziq")*(B1:B9=""),(A1:A9="Muziq ")*(B1:B9="")*1))
*Entered as an array formula with Ctrl+Shift+Enter

As with pretty much anything in Excel, There are several ways to get
the results he's looking for