| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count similar text with using filters
I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still counts all the "Y". |
|
#2
|
|||
|
|||
|
Quote:
Prefer pivot table and use count of Y's. It will show you proper count now even after filter also.
__________________
Thanks Bala |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count similar text with using filters
Hi,
try =SUMPRODUCT(SUBTOTAL(3,OFFSET(d2:d11,ROW(d2:d11)-MIN(ROW(d2:d11)),,1)), --(d2:d11="Y")) change range to fit your needs "mj" wrote: I want to count the number of occourances of a "Y" in coulumn D .. so i used a countif and it works great however when i filter another column it still counts all the "Y". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Question - Similar Data | Excel Worksheet Functions | |||
| How to make the record count always show when using filters... | Excel Discussion (Misc queries) | |||
| Count/average function with filters | Excel Worksheet Functions | |||
| How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
| How can I count similar word in raw? | Excel Discussion (Misc queries) | |||
Hybrid Mode
