formula to count non duplicate numbers

[purelutz135]

hello there, is it possible to get a formula that can output the # of non duplicate values in a range of cells. below i have put in bold non duplicate values in the row to count as an example. thanks.

formula	numbers
0​	1​	2​	3​	4​	5​
3​	2​	4​	6​	6​	3​
1​	1​	1​	1​	3​	1​
1​	3​	4​	3​	4​	1​

 

[jasonb75]

Try

=SUMPRODUCT(--(COUNTIF(B2:F2,B2:F2)=1))

 

[purelutz135]

typo in first post. should be 5 in first row not 0.

hello there, is it possible to get a formula that can output the # of non duplicate values in a range of cells. below i have put in bold non duplicate values in the row to count as an example. thanks.

formula	numbers
5​	1​	2​	3​	4​	5​
3​	2​	4​	6​	6​	3​
1​	1​	1​	1​	3​	1​
1​	3​	4​	3​	4​	1​