COUNTIF function


Excel » Functions » Statistical » COUNTIF function »

COUNTIF 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

You have quite a few options to choose from if you are looking for a way to create a unique […]

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 […]