## COUNTIF function

Excel ยป Functions ยป Statistical ยป COUNTIF function ยป

How to use the COUNTIF function to count not blank cells

The COUNTIF function is very capable of counting non-empty values. Column B above have a few blank cells, they are [โฆ]

If cell contains text

The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and [โฆ]

Use IF + COUNTIF to perform numerous conditions

The COUNTIF function allows you to construct a small IF formula that carries out plenty of logical expressions. Combining the IF [โฆ]

How to use the COUNTIF function

Counts the number of cells that meet a specific condition.

How to create a list of random unique numbers

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and [โฆ]

Count unique distinct values

This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are [โฆ]

5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference [โฆ]

Extract shared values between two columns

Question: How can I compare two columns to find values that exists in both cell ranges? The picture above shows [โฆ]