COUNT Skill Summary

Freeintermediate 20 min4 tasks0/48 pts

Bring the counting family together: COUNT for numbers, COUNTA for anything filled in, COUNTIF for one condition and COUNTIFS for several.

Syntax

COUNT · COUNTA · COUNTIF(range, criteria) · COUNTIFS(range1, criteria1, …)

Common mistakes

Using COUNT on text columns (it returns 0).
Using COUNTIF when two conditions are needed.

Other Count Functions (COUNTA, COUNTBLANK)Debugging SUM Functions