Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Counting filtered entries in Excel

by shandygaff Sep 26, 2004 2:37PM PDT

I know there is a function in Excel where it counts the records you have filtered and puts the count in the status bar at the bottom of the screen. On some machines this is turned on and some it is turned off. However, after an extensive search, I cannot find where to turn this function on. Can anyone help please?

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

Re: Counting filtered entries in Excel

by Eddiesix Oct 29, 2004 4:55AM PDT

Hey..

I found a method to do this on the web. Basically, go to the bottom of your filtered sheet and enter this function into an empty cell:

=SUBTOTAL(3,D:D)-1

Note: when I did the above I got a smiley face! The function is:

=SUBTOTAL(3,DcolonD)-1 (that is the cap letter "D" a colon and then another "D" after that (no spaces)

Then click off to another cell and it will automatically count the number of filtered rows. This also keeps working if you add or delete rows.

To read the complete article about how to do this go here:
http://www.bettersolutions.com/excel/122425999101012160192202312419/122425914241725132023120231245.htm

I tried this.. it works!
Ed
eddiesix@ix.netcom.com