sumproduct formula help

Hi,

I am using a formula to count how many different products there are in a list =sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10)) so if there was 8 different products in those 10 rows and 2 products appeared twice the result would show 8.

I can't figure out how to make it ignore blank cells though. If one of the cells is blank it returns #DIV/0.

Can anyone help please?

Thanks

Attach a sample workbook showing the issue.

Go Advanced -> Manage Attachments -> Upload

Try

=SUMPRODUCT((A2:A10<>"")/COUNTIF(A2:A10,A2:A10&""))

Thanks Azumi that got it perfect.