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.

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.

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.

>=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" <(E-Mail Removed)> wrote in message
news:2C7F9D9C-486E-4C85-A14A-(E-Mail Removed)...
> 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.