## The formula to count unique numeric values with criteria

To do that in excel, you can use a formula based on the SUM and FREQUENCY functions, together with the FUNCTION to apply criteria.

Skip to content
# Tag: FREQUENCY

## The formula to count unique numeric values with criteria

To do that in excel, you can use a formula based on the SUM and FREQUENCY functions, together with the FUNCTION to apply criteria.

## The formula to count unique numeric values in a range

FREQUENCY function in Excel calculates how often values occur within a range of values, and then returns a vertical array of numbers.

This formula is exactly what you want. You can use a formula that uses the FREQUENCY function together with the SUM function to count unique numeric values in a range.