Distinct count values from multiple columns in excel

Question

Hello is there any function to count the distinct values of 3 or 4 columns so i do not have temp tables and other things. Also excel vba is not a case.

Like i want to count distinct languages in the table (it did not let me to place it as data). Do you want more info for help? Also some cells could be empty.

Answer 1

A simple reciprocal of a COUNTIF in a SUMPRODUCT:

=SUMPRODUCT((A2:C10<>"")/(COUNTIF(A2:C10,A2:C10)+(A2:C10="")))

Answer 2

Taking help of Scott i fount that

=SUMPRODUCT((A6:C14<>"")/(COUNTIF(A6:C14;A6:C14&"")))

will do the work