View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default 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.