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