2.4 Count what's there

Ten people signed up for a workshop. Column B shows what each person paid; Fay's place is free. In E2, count everyone who signed up. In E3, count the people who have paid. In E4, count the people who still have to pay.

COUNTA counts every cell that isn't empty. COUNT counts only cells with numbers. COUNTBLANK counts the empty ones.

03 Count what's there COUNT, COUNTA, COUNTBLANK Starter

Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.

Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.