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

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

Skip to content
# Excel Formulas

# Archives

## 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

## How to count cells that contain numbers in excel

All formulas in Microsoft Excel

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

You want to figure out how many cells that contain numbers or contain characters. This formula will help you do that.