Excel Exercise


2 minutes

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



​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.