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


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top