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

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

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

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

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

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

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\$

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

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 …

## How to count cells that are blank or not 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)

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

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

## How to count cells that contain numbers in excel

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