Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. SUM, AVERAGE and COUNT

COUNT, COUNTA and COUNTBLANK practice: count orders, names and blanks

  • Beginner
  • ~4 min
  • SUM, AVERAGE and COUNT

A CRM export lists 80 customers with their company, contact name, email, the number of orders placed in 2026 and the last order date. The export is not clean: some contact names are missing and a few order counts came through as the text "n/a". Sales operations wants three quick numbers for the Monday report: how many customers have a usable order count, how many contacts are on file, and how many contact names are missing.

What you need to do

  1. 1Click I2 and write a COUNT formula over the Orders column E2:E81. COUNT only counts cells that hold numbers, so the "n/a" entries are skipped.
  2. 2Click I3 and write a COUNTA formula over the Contact name column C2:C81. COUNTA counts every non-empty cell, text included.
  3. 3Click I4 and write a COUNTBLANK formula over the same column C2:C81 to count the empty cells.
  4. 4Press Enter after each formula and check that I3 + I4 equals the number of customers.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn I2, use COUNT to count how many customers have a numeric value in Orders (2026) (E2:E81).
  2. Not checkedIn I3, use COUNTA to count how many contact names are on file (C2:C81).
  3. Not checkedIn I4, use COUNTBLANK to count how many contact names are missing (C2:C81).

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 80-row dataset on one sheet, 3 answer cells, about 4 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • I2=COUNT(E2:E81)
  • I3=COUNTA(C2:C81)
  • I4=COUNTBLANK(C2:C81)

The three functions differ only in what they count. COUNT looks at E2:E81 and counts the 75 cells that contain numbers, skipping the 5 cells with the text "n/a". COUNTA counts every cell in C2:C81 that is not empty (71), and COUNTBLANK counts the 9 empty ones, which is why I3 and I4 add up to 80.

Pitfall 1: COUNT ignores text that merely looks like a number ("12" stored as text), so a column imported from a CSV can return a smaller count than you expect; use VALUE or Paste Special → Multiply by 1 to convert first. Pitfall 2: a cell containing a formula that returns "" is counted by COUNTA and also by COUNTBLANK, so the two can add up to more than the row count after you add helper formulas. Alternatives: COUNTIF(E2:E81,"<>n/a") counts the numeric rows when you know the text marker; SUMPRODUCT(--ISNUMBER(E2:E81)) is the array-style equivalent of COUNT and survives being nested in bigger formulas. Performance: all three are O(n) and fine on hundreds of thousands of rows; never wrap them in volatile functions like INDIRECT when the ranges can be whole columns instead.

Other ways that work

  • =COUNTIF(E2:E81,"<>n/a") — same result as COUNT here because the only non-numbers are the "n/a" cells
  • =SUMPRODUCT(--ISNUMBER(E2:E81)) — array-style equivalent of COUNT
  • =ROWS(C2:C81)-COUNTA(C2:C81) — same as COUNTBLANK

Common mistakes

Writing =COUNT(C2:C81) for the contact names. Names are text, so COUNT returns 0 — the function for "how many cells are filled" is COUNTA.

How we grade

Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.

Answers computed with Excel 365 rules and checked in our grading engine on November 15, 2026. Author: GridBelt team.

In these programs

  • Excel test in 7 days, Level 1 planDay 4
  • Excel for Administrative AssistantsDay 2
  • Learn Excel From ScratchDay 4

Related exercises

  • Total revenue with SUMBeginner, ~3 min
  • AVERAGE, MIN and MAX of exam scoresBeginner, ~4 min
  • Top 3 and bottom 3 reps with LARGE and SMALLBeginner, ~5 min
  • Filter one region and count visible rows with SUBTOTALBeginner, ~6 min

Function reference

Official documentation

Next exercise

Row totals with the fill handle