| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count rows in a filtered list when using AutoFilter? | Excel Worksheet Functions | |||
| count filtered rows based on condition greater than forty | Excel Worksheet Functions | |||
| Display count of filtered rows | Excel Discussion (Misc queries) | |||
| How do I count the number of filtered rows | Excel Worksheet Functions | |||
| Unique Count sensitive to hidden/filtered rows | Excel Worksheet Functions | |||
Linear Mode
