... of unique number values in cells A2:A10, but do not count blank cells or text values (4) */
=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
/* Count the number of unique text and number values in cells B2:B10 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.