This formula shows one way to count unique values, as long as they are numeric.
We use it here as a roundabout way to count unique numeric values.
Note: you could also use SUMPRODUCT to sum the items in the array.
The FREQUENCY formula, while more complicated, calculates much faster.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
COUNTIF can be used to count…
