But who's COUNTing?

Analysis in Excel

Jen Bricker

Head of Career Services, DataCamp

Data analysis process review

Diagram of the Data Analysis Process

Analysis in Excel

Data analysis process review

Diagram of the Data Analysis Process focused on the Analyze Data step

Analysis in Excel

Counting in Excel

  • Count the number of cells
  • A few variations of COUNT()
    • COUNT()
    • COUNTA()
    • COUNTBLANK()
Analysis in Excel

COUNT() function explained

Counts the number of cells that contains numeric values in a range

Syntax:

=COUNT(value_range)

Example:

=COUNT(M2:N11)

Analysis in Excel

COUNTA() function explained

Counts all non-blank cells in a range regardless of data type

Syntax:

=COUNTA(value_range)

Example:

=COUNTA(M2:N11)

Analysis in Excel

COUNTBLANK() function explained

Counts all blank cells in a range

Syntax:

=COUNTBLANK(value_range)

Example:

=COUNTBLANK(M2:N11)

Notes:

  • Cells with formulas that return "" are counted
  • Cells with zero values are not counted
Analysis in Excel

Output

Table showing the results of the count functions

Analysis in Excel

Output

Table showing the results of the count functions

Analysis in Excel

Output

Table showing the results of the count functions

Analysis in Excel

Cleaning data revisited

Diagram of an iterative Data Analysis Process

Analysis in Excel

Let's practice!

Analysis in Excel

Preparing Video For Download...