The sign-in board covers B3:E7. Only three spaces have names today, but you need to know how many spaces the layout allows. Measure the rectangle instead of counting entries.

Count rows and columns from the same range

=ROWS(B3:E7)*COLUMNS(B3:E7)

The range spans five rows and four columns. The multiplication returns 20 even when cells are empty. Fill or clear a slot and the capacity stays the same.

The marked rectangle spans columns B through E and rows 3 through 7.

Illustrated layout. Count the selected rectangle from its edges.

Check the shape and occupied positions separately

Count 5 × 4 by eye on the sample. The 3 occupied positions leave 17 empty if each name takes exactly one cell. If merged cells, divider cells or reserved positions change what counts as a slot, use the actual slot layout or subtract those positions explicitly. The range formula measures the rectangle as written.

Three occupied cells and 17 empty cells still give a capacity of 20.

Illustrated check. Compare capacity with occupancy separately.

Microsoft’s Excel function reference