Sheetsdrill

Level 2: Conditional counting and summing Exercise 17 of 92

Late deliveries

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Count the orders whose status is "Late". Answer in E1.

What this exercise teaches

COUNTIF is the one-condition version of COUNTIFS. It ignores capitals, so Late and late count the same.

A hint if you get stuck

COUNTIF(range, criterion) counts the cells that match. Text criteria go inside double quotes.

Functions used: COUNTIF

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Conditional counting and summing