Ask Your Question

Revision history [back]

Put this formula beneath one of your columns. It will count the total viable rows.

=SUBTOTAL(3,range_start:range_end)

This worked for me in in LibreOffice 4. I'm not sure what the 3 parameter is for, but it works better than 2. Source:
http://www.mrexcel.com/archive/Data/18424.html