Find unique values when blank cells

[webmax]

Hi
I try to find unique values in the data. but when data is blank it is showing as Div Error.
In this example Range B3: I3 I have two unique values Revenue and cost. so that outcome as 2 but showing as #Div/0! Error.
How to resolve this issue. Attaching excel sheet for your reference

Thanks

 

[Excel Wizard]

Please try at J2
=SUMPRODUCT((B2:I2<>"")/COUNTIF(B2:I2,B2:I2&""))

 

[webmax]

thanks

 

[webmax]

Hi can you explain about the below formula. how it works
Please try at J2
=SUMPRODUCT((B2:I2<>"")/COUNTIF(B2:I2,B2:I2&""))

 

[pecoflyer]

Try the "Evaluate formula tool" to see the formula at work