Task 1 of 3
In E2, count how many employees have a number in the sales column (B).
Lesson theory
=COUNT(B2:B9)counts the cells that contain numbers.=COUNTA(A2:A9)counts the non-empty cells (numbers, text, anything).=COUNTBLANK(B2:B9)counts the empty cells.
This is a quick way to check a table: is everything filled in, and how many real numbers are there?
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page