All lessons
Conditional TotalsintermediatePro

COUNTIF & SUMIF

Count or add up only the rows that match a condition — one of the most useful skills for real spreadsheet work.

Read the full guide to COUNTIF and SUMIF in Excel →

COUNTIF & SUMIF is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans