Count unique value ignoring Text in range
Here's a solution:
Array enter the following formula anywhere:
{=SUM(IFERROR(1/COUNTIF(D1:D12,IFERROR(--D1:D12,)),))}
For the benefit of community I would also like to suggest an array formula with differnt approach, "to count unique values by ignoring text in the given data range".
{=SUM(IF(FREQUENCY(A2:A13,A2:A13)>0,1,0))}
Note, finish the formula with Ctrl+Shift+Enter.
Here's another solution inspired by Rajesh's own answer:
Enter the following formula anywhere:
=SUM(--(FREQUENCY(D1:D12,D1:D12)>0))
Note that this formula doesn't have to be array entered.