As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## How to Use the COUNTIF Function in Excel: A Quick Guide

The Excel COUNTIF function is a powerful tool for counting cells that meet specific criteria. Here's a quick guide on how to use it.

#### Syntax:

=COUNTIF(range, criteria)

• range: The range of cells to be counted.
• criteria: The criteria to be met by the cells in the range.

#### Examples:

1. Count Cells Greater Than 10:

=COUNTIF(A1:A10, ">10")

This formula counts the number of cells in the range A1:A10 that are greater than 10.

2. Count Text Cells:

=COUNTIF(B1:B10, "Text")

This formula counts the cells in the range B1:B10 that contain the text "Text".

3. Count Non-Blank Cells:

=COUNTIF(C1:C10, "<>")

This formula counts the number of non-blank cells in the range C1:C10.

Wildcard Characters:

You can use wildcard characters (* for any number of characters, ? for a single character) in the criteria. For example:

=COUNTIF(D1:D10, "A*")

Combining Criteria:

You can combine criteria using the COUNTIFS function for multiple conditions. For example:

=COUNTIFS(A1:A10, ">10", B1:B10, "Text")

This counts cells where column A is greater than 10 and column B contains the text "Text".

Dynamic Criteria:

You can use cell references for dynamic criteria. For example:

=COUNTIF(E1:E10, ">" & F1)

Assuming F1 contains a number, this counts cells in the range E1:E10 that are greater than the number in cell F1.

#### Usage:

1. Entering the Formula:
2. Click on the cell where you want the result.
3. Type =COUNTIF( to start the formula.
4. Enter the range and criteria.
5. Close the parentheses and press Enter.