ƒx

Excel COUNTIF Formula

data Difficulty:

One-Click Copy

COUNTIF(range, criteria)

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Counts the number of cells within a range that meet a single criterion.

Count items that match a specific condition.

Count with Condition

Count items that match a specific condition.

Inputs

range The group of cells you want to count.
criteria The condition that defines which cells will be counted.

Practical Example

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

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.