• Home
  • Counting blank rows

Counting blank rows

Counting blank rows exercise screenshot

0 comments

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

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>