COUNTIF practice

COUNTIF counts the cells in a range that meet one condition. Below are the 3 Excel exercises on Formuladrill that use it, each checked instantly in your browser.

Syntax

COUNTIF(range, criterion)

What people get wrong

Criteria are text, so a comparison is written in quotes: ">=100", or joined to a cell: ">="&B1.

Excel exercises that use COUNTIF

• Count the shipped ordersLevel 2Pro
• Scores above a barLevel 2Pro
• Flag duplicate ordersLevel 6Pro

Often used together with: IF