Excel Exercise

Easy

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

COUNT

COUNTA

​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.

>