Counting blank rows

Count the number of blank rows (not cells) in the product table A1:B20 using the COUNTBLANK function.

Alternatively, you can combine the total number of rows (19) and the COUNT function to get to the answer.

Spreadsheet editor
Nice work!

Related functions

COUNT

COUNTA

Leave a Comment