Excel Study · Module 1: First steps
Class 4COUNT, COUNTA & COUNTBLANK
Basics1:24 videoFree
Three ways to count in Excel. COUNT counts only numbers, COUNTA counts every cell that is not empty (text included), and COUNTBLANK counts the empty cells. Here: homework marks where one student is "Absent" and two cells are blank.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, cells B2 to B8 have homework marks, but some cells are empty and one says Absent. Write a formula that counts how many students got a mark.
The answer that works
✓ checked in Excel=COUNT(B2:B8)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.