Ask Your Question

Calc Filter Results Count

asked 2012-08-19 17:19:43 +0100

ecoten gravatar image

When using auto-filter or standard filter in Calc is there any easy way to see how many rows are being displayed that match the specified filter settings?

I have found a workaround which is to right click on the Sum indication on the status bar at the bottom and change it to CountA then select a column of the results where every row has a value in. This seems to show how many rows there are but seems a bit clumsy is there a better way?

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2015-07-10 17:11:27 +0100

steelman gravatar image

if you rather not use formulas type 1 on the first row in a new column, then double click on the lower right of this column, it will automatically populate all the filtered rows while incrementing the 1. You can scroll down then to the bottom and see the value of this column to read the count

edit flag offensive delete link more


Upvoting because it's a nice idea. The ideal answer would be that this functionality is now built into LibreOffice but this seems an equally good workaround to the one mentioned in the question

ecoten gravatar imageecoten ( 2015-07-13 22:13:57 +0100 )edit

answered 2018-11-23 09:42:43 +0100

Easiest way I've found is:image description

  • Select all (autofiltered) rows
  • Right click in the status bar like in the screenshot
  • Check "CountA"

CountA will show you the number of selected rows.

edit flag offensive delete link more


This seems to be what I have an elaboration of the suggestion I made in the question

ecoten gravatar imageecoten ( 2018-11-25 16:13:41 +0100 )edit

answered 2015-03-18 16:06:30 +0100

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


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:

edit flag offensive delete link more

answered 2013-03-13 12:42:11 +0100

qubit gravatar image

Hi @ecoten,

Still looking for an answer to your question?

edit flag offensive delete link more


Yes please, if you have one.

ecoten gravatar imageecoten ( 2014-03-28 12:49:41 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2012-08-19 17:19:43 +0100

Seen: 9,106 times

Last updated: Nov 23 '18