Ask Your Question
0

Calc Filter Results Count

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

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
2

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

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

Comments

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 +0200 )edit
0

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

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

Comments

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 +0200 )edit
0

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

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

edit flag offensive delete link more
0

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

qubit gravatar image

Hi @ecoten,

Still looking for an answer to your question?

edit flag offensive delete link more

Comments

Yes please, if you have one.

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

Question Tools

1 follower

Stats

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

Seen: 10,246 times

Last updated: Nov 23 '18