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

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.

Skip to content
# Category: Count

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

## The formula to count size of common set of two columns in excel

## The formula to count rows with multiple OR criteria in Excel

## The formula to count rows that have the same value in two columns

## The formula to count rows that have two criteria match in excel

## How to find and count cells that contain specific text in excel

## How to count cells that are blank or not in excel

## The formula to figure out odd numbers and count them in excel

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.

In Excel we can count size of common set by using a formula that combines the COUNTIF and SUMPRODUCT functions.

You can count rows with two or more “AND” criteria in Excel with this formula. How to count rows with multiple OR criteria in Excel, the formula in this article will help you do that

You want to compare two columns and count matches in corresponding rows. In example row 1, 2 and 5 are matches in corresponding rows.

You have a table have a column contain name product and a column contains price. Suppose you want to count how many product have the name is Apple and have the price greater than 1,000$

Case 1 Suppose you have a range, such as A1:A10 each cell contains a code of a product. Code format: AAAXXXYYYZZZ, AAA represents a name of the company, XXX represents a name of this product; YYY represents for the year made this product and ZZZ represents for the price. Now you need to find all …

Continue reading “How to find and count cells that contain specific text in excel”

To count the number of cells that are blank or not blank, you can use the COUNTBLANK function with the formula: =COUNTBLANK(range)

You want to figure out odd or even numbers and count them in excel. This article will help you know odd and even number in excel by using MOD function