Count cells that are unique numbers
{=SUM(IF(FREQUENCY(CellRange,CellRange)>0,1,0))} = #N/A
This formula does not work when some of the cells contain error values.
Related Formulas
Count cells that are unique text strings
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top