Excel FunctionsLesson 77Free preview

COUNT

This lesson is part of Excel · All levels

Summary

COUNT counts the number of cells that contain numbers in the range, so text and empty cells are not counted. The COUNTA version counts all the non-empty cells, and the COUNTIF counts the cells that meet one criterion. Choosing the right variant makes data retrieval much more accurate.

Key points

COUNT just counts the cells containing the numbers
COUNTA counts all the empty cells
COUNTIF calculates based on one criterion
Text cells and empty cells are not counted

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.