Count Advanced Filtered Rows
 

Hello,
I have an advanced filtered sheet that has criteria in two adjacent columns
for the following criteria:
*pharm*
*drug*
*rx*
*script*

The filter works, however I want to be able to count only the number of
records shown. How can I do that?

Thanks.

Count Advanced Filtered Rows
 

say your filtered range is A1:a100 then

=subtotal(2,a1:a100) will count the number of records displayed

"Daren" wrote:

Hello,
I have an advanced filtered sheet that has criteria in two adjacent columns
for the following criteria:
*pharm*
*drug*
*rx*
*script*

The filter works, however I want to be able to count only the number of
records shown. How can I do that?

Thanks.

Count Advanced Filtered Rows
 

Tried your suggestion but it returned a 0. Do you know what I might have
done incorrectly, if anything?

"N harkawat" wrote:

say your filtered range is A1:a100 then

=subtotal(2,a1:a100) will count the number of records displayed

"Daren" wrote:

Hello,
I have an advanced filtered sheet that has criteria in two adjacent columns
for the following criteria:
*pharm*
*drug*
*rx*
*script*

The filter works, however I want to be able to count only the number of
records shown. How can I do that?

Thanks.

Count Advanced Filtered Rows
 

=subtotal(2,a1:a100) will count the number of records displayed

That will count *numbers* in the filtered range.

Replace 2 with 3.

That will count any cells that are not empty.


--
Biff
Microsoft Excel MVP


"Daren" wrote in message
...
Tried your suggestion but it returned a 0. Do you know what I might have
done incorrectly, if anything?

"N harkawat" wrote:

say your filtered range is A1:a100 then

=subtotal(2,a1:a100) will count the number of records displayed

"Daren" wrote:

Hello,
I have an advanced filtered sheet that has criteria in two adjacent
columns
for the following criteria:
*pharm*
*drug*
*rx*
*script*

The filter works, however I want to be able to count only the number of
records shown. How can I do that?

Thanks.