To count unique values in Excel, one way you can use is the combination of the COUNTIF, IFERROR, and SUM functions. To give an example, assume that you want to count unique values in the range of (A1:A10). Type the formula below in the cell that you want to see the result and then press Ctrl+Shift+Enter: =SUM(IFERROR(1/COUNTIF(A1:A10,A1:A10),"empty"))