How to count distinct and unique values in Excel

=COUNTIF(A2:A23|A2:A23)
=SUM(IF(COUNTIF(A2:A23|A2:A23)=1|1|0))