Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson

Dave,
Thanks for the suggestion. However, I was hoping that once I clicked the
AutoFilter "arrow" on a given column and selected the criteria to filter on,
Excel would automatically display (maybe in the status area) the number of
rows that met the criteria, thereby avoiding the need to write a formula.
Bob


"Dave Peterson" wrote:

=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson

Excel will try to help by displaying a message in the statusbar (make sure you
have it visible (tools|Options|View tab).

But sometimes, it won't:
http://contextures.com/xlautofilter02.html#Count
(From Debra Dalgleish's site)

Bob wrote:

Dave,
Thanks for the suggestion. However, I was hoping that once I clicked the
AutoFilter "arrow" on a given column and selected the criteria to filter on,
Excel would automatically display (maybe in the status area) the number of
rows that met the criteria, thereby avoiding the need to write a formula.
Bob

"Dave Peterson" wrote:

=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson


--

Dave Peterson

Dave,
Thanks for the info! I went to Debra Dalgleish's site and clicked on the
two Microsoft Knowledge Base links. What I learned is if I set Calculation
to Manual, I then get a count of the filtered rows in the Status bar.
Thanks again,
Bob


"Dave Peterson" wrote:

Excel will try to help by displaying a message in the statusbar (make sure you
have it visible (tools|Options|View tab).

But sometimes, it won't:
http://contextures.com/xlautofilter02.html#Count
(From Debra Dalgleish's site)

Bob wrote:

Dave,
Thanks for the suggestion. However, I was hoping that once I clicked the
AutoFilter "arrow" on a given column and selected the criteria to filter on,
Excel would automatically display (maybe in the status area) the number of
rows that met the criteria, thereby avoiding the need to write a formula.
Bob

"Dave Peterson" wrote:

=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson


--

Dave Peterson

Don't forget to toggle it back on before you trust any formulas.

Bob wrote:

Dave,
Thanks for the info! I went to Debra Dalgleish's site and clicked on the
two Microsoft Knowledge Base links. What I learned is if I set Calculation
to Manual, I then get a count of the filtered rows in the Status bar.
Thanks again,
Bob

"Dave Peterson" wrote:

Excel will try to help by displaying a message in the statusbar (make sure you
have it visible (tools|Options|View tab).

But sometimes, it won't:
http://contextures.com/xlautofilter02.html#Count
(From Debra Dalgleish's site)

Bob wrote:

Dave,
Thanks for the suggestion. However, I was hoping that once I clicked the
AutoFilter "arrow" on a given column and selected the criteria to filter on,
Excel would automatically display (maybe in the status area) the number of
rows that met the criteria, thereby avoiding the need to write a formula.
Bob

"Dave Peterson" wrote:

=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson