Numbers app

To count the blank rows you can do something like this:

1. Click the Column Letter
2. Choose Quick Filter... from the dropdown
3. Read the number to the right of (Blank).

However, you might be better off getting rid of those blank rows in your data. Sort Ascending or Sort Descending will force them all to the bottom of the table, where you can select them and delete them.

SG

The filter method looks at a selected column, not the entire row. It will work to count blank rows if all "non-spacer" rows have an entry in that column. But if a "non-spacer" row is blank in that column, it will be included in the "blank" count. It will work with your database if you have at least one column that MUST be filled in when entering the data.

An alternative is to use the COUNTA function in a new column to count how many cells in that row have something in them. If the result is 0, it is a blank row.

Formula in D2 is =COUNTA(A2:C2)

fill down to complete the column

If all you want is to know how many are blank, in the header row put a formula such as

="Blank = "&COUNTIF(D,0)

Or filter by column D and delete the empty rows or whatever you need to do.