COUNTIF practice

COUNTIF counts the cells in a range that meet one condition. Below are the 2 financial modeling exercises on Modeldrill 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.

financial modeling exercises that use COUNTIF

• Payback periodLevel 5Pro
• Cohort payback by monthLevel 5Pro

Often used together with: INDEX, SUM