ExamFinch.com My Study

Study guide

COUNT, COUNTA, and COUNTBLANK

Practice this exam

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

COUNT, COUNTA, and COUNTBLANK

Key Takeaways Explain This Topic AI

COUNT tallies cells that contain numbers; COUNTA tallies non-empty cells (numbers, text, errors, logicals)

COUNTBLANK tallies empty cells in a range—the Associate tool for "how many blanks" questions

The classic trap: using COUNT on a column of names or IDs stored as text returns 0 or undercounts

AutoSum → Count Numbers inserts COUNT, not COUNTA—choose deliberately when the data is text

  • MO-210 projects specify which count function; matching the wrong cousin with a plausible number still fails
  • Last updated: August 2026

Counting on the Associate blueprint

Still under Calculate and transform data , MO-210 expects you to count cells correctly—not just sum them. The three functions you must keep straight are COUNT , COUNTA , and COUNTBLANK . They look similar in the formula bar and often sit in the same AutoSum family, but they answer different questions. Mixing them up is one of the most common Domain 4 score losses because the wrong function can still return a number that looks reasonable until a grader reads the formula.

Task cues: "Count how many numeric scores appear in column D" , "How many cells in A2:A50 contain an entry?" , "Display the number of blank cells in the Status column" , or "Use a function to count non-empty product names." Map the wording to the function before you type.

Syntax comparison

  • Function Syntax Counts
  • COUNT =COUNT(value1, [value2], …) Cells with numbers (dates/times count as numbers)
  • COUNTA =COUNTA(value1, [value2], …) Cells that are not empty (text, numbers, TRUE/FALSE, errors)
  • COUNTBLANK =COUNTBLANK(range) Cells that are empty

COUNTBLANK takes a range (typically one argument). COUNT and COUNTA accept ranges and lists like other aggregates: =COUNTA(A2:A20) or =COUNT(B2:B20, D2:D20) .

COUNT — numbers only

COUNT ignores blanks, text, and most non-numeric content. Use it when the project cares about how many numeric values exist.

Worked example: mixed score column

  • D (Score)
  • 2 88
  • 3 92
  • 4 (blank)
  • 5 Absent
  • 6 75
  • 7 0 =COUNT(D2:D7) → 4

Counted: 88 , 92 , 75 , and 0 . Not counted: the blank and the text Absent . Zero is numeric—COUNT includes it. That surprises candidates who treat zero like "no data."

Dates such as 3/15/2026 are stored as serial numbers, so COUNT includes them. If a project asks how many dates were entered in a column of mixed blanks and date values, COUNT is usually correct.

COUNTA — anything non-empty

COUNTA ("count all" non-blanks) is the function for inventory of filled cells: names, IDs, statuses, comments, and numbers alike.

Using the same D2:D7 range: =COUNTA(D2:D7) → 5

Counted: every row except the blank—including the text Absent and the zero. COUNTA does not mean "count text only"; it means "count cells that have something in them."

Worked example: employee name list

Column A holds employee names in A2:A30 , with some unused rows still blank at the bottom of a pre-formatted range. =COUNTA(A2:A30)

returns how many names were entered. =COUNT(A2:A30) returns 0 (or near zero) because names are text. That is the signature Associate trap: the sheet "looks full," COUNT looks like the right English word, and the formula returns zero.

The COUNT vs COUNTA trap (memorize this)

  • Situation Prefer
  • How many numeric scores / quantities / prices? COUNT
  • How many names, IDs, labels, or filled cells of any type? COUNTA
  • How many empty slots remain? COUNTBLANK

If the instruction says "count the number of values" while pointing at a text column, interpret that as COUNTA. If it says "count numbers" or AutoSum Count Numbers , that maps to COUNT.

COUNTBLANK — empty cells

COUNTBLANK reports how many cells in the range are empty.

  • Worked example: incomplete survey
  • Range F2:F11 has seven answers filled and three cells never touched. =COUNTBLANK(F2:F11) → 3

Useful exam patterns: remaining seats, missing scores, incomplete status fields. Note the relationship on a fixed range: COUNTA(range) + COUNTBLANK(range) = number of cells in the range

(Assuming no oddities like cells that look blank but contain formulas returning "" —a formula that returns an empty string is often treated as blank by COUNTBLANK and as non-empty by COUNTA depending on Excel's rules; Associate projects usually use truly empty cells.)

For straightforward MOS data, stick to the rule: untouched cells → COUNTBLANK; typed content → COUNTA; typed numbers → COUNT.

AutoSum and Count Numbers

The AutoSum drop-down includes Count Numbers , which inserts COUNT , not COUNTA. Example after choosing Count Numbers below a column: =COUNT(B2:B15)

If the column is product SKUs stored as text ( "AB-100" ), Count Numbers returns 0. You must type =COUNTA(B2:B15) yourself. Do not assume the AutoSum menu covers every counting scenario on the exam.

There is no AutoSum shortcut named "Count Blank"; type COUNTBLANK when the project asks for blanks.

Worked scenario: registration sheet

A workshop roster uses:

  • A2:A40 — participant names (text)
  • B2:B40 — fee paid (currency numbers or blank)
  • C2:C40 — check-in status ( Yes , No , or blank)

Summary cells the project might require:

  • Cell Formula Meaning
  • E2 =COUNTA(A2:A40) How many names registered
  • E3 =COUNT(B2:B40) How many fees recorded as numbers
  • E4 =COUNTBLANK(C2:C40) How many have not checked in yet
  • E5 =COUNTA(C2:C40) How many have a Yes/No status entered

Notice E3 and E2 can differ: someone listed without a fee leaves a blank in column B. COUNT of fees is not the same as COUNTA of names. Read which column and which idea the task wants.

Interaction with AVERAGE and SUM

AVERAGE and SUM already ignore blanks and text. You do not need COUNT to "help" AVERAGE. Avoid constructions like =SUM(D2:D10)/COUNTA(D2:D10) when text labels sit in the same column—that divides by too many cells. Prefer =AVERAGE(D2:D10) for numeric means, and use COUNT only when the deliverable is a count , not an average.

Common MO-210 traps

Using COUNT on a text name/ID column and getting 0.

Using COUNTA when the task explicitly wants numeric entries only (for example, "count how many numeric ratings were submitted").

Forgetting that zero counts as a number for COUNT.

Choosing Count Numbers from AutoSum for a text list.

Counting the header row by including row 1 in the range ( A1:A40 instead of A2:A40 ).

Using LEN or FILTER (beyond Associate scope for this objective) when COUNTBLANK was requested.

Practice sequence

Fill A1:A5 with names and one blank; compare =COUNT(A1:A5) (0) vs =COUNTA(A1:A5) (4) vs =COUNTBLANK(A1:A5) (1).

Put numbers and one text note in B1:B5; confirm COUNT ignores the note while COUNTA includes it.

Use AutoSum → Count Numbers under a numeric column; then repeat under a text column and replace with COUNTA.

Build the registration-style trio: COUNTA names, COUNT fees, COUNTBLANK status—label each result so you associate English with the function.

If you can explain in one sentence why COUNT returns 0 on a full column of names, you have the Associate-level counting skill locked for Domain 4.