Excel Function

COUNTIF

Counts cells matching a condition.

COUNTIF(range, criteria)

Arguments

range

Required

Specify the range used for condition check or aggregation.

criteria

Required

Enter the match condition, e.g. "Food", ">=80", "<>0".

Practice Preview

Use COUNTIF to count rows where Category matches Food.

Example Table

#	AProduct ID	BProduct Name	CCategory	DSales
2	P001	Apple	Food	1200
3	P002	Banana	Food	980
4	P003	Notebook	Stationery	450
5	P004	Pen	Stationery	300
6	P005	Grapes	Food	1500
7	P006	Ruler	Stationery	250
8	P007	Peach	Food	860

How to Use (Formula)

=COUNTIF(C2:C8, "Food")

Result

Practice This Function

Start Function Practice Back to Function List

COUNTIF FAQ

How do I use COUNTIF in Excel?

Use COUNTIF when you want to count rows or cells that match a condition. Enter Range, Criteria in that order, then add optional arguments when needed.

Where can I practice COUNTIF?

Use the "Start Function Practice" button to jump straight into COUNTIF drills.

What arguments does COUNTIF use?

The main arguments are Range, Criteria. Enter them in order.