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

yshridhar,
That'll give him the total count for that product but he don't want to
count all of the products, he only wants to count the product if
column B is blank