Count unique value ignoring Text in range

Here's a solution:

Worksheet Screenshot

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".

enter image description here

{=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:

Worksheet Screenshot

Enter the following formula anywhere:

=SUM(--(FREQUENCY(D1:D12,D1:D12)>0))

Note that this formula doesn't have to be array entered.