crazy_papaya
New Member
- Joined
- Feb 10, 2020
- Messages
- 28
- Office Version
- 2016
- Platform
- Windows
- Web
Hi all,
How can we count the total number of rows/ products in "Product name" and also for the count to change every time a filter is used.
So for ex - In table below If I filter out P1 then I want total to show "3" and if filter nothing, total becomes back to "4"
I have found out how to count number in a dynamic way using =SUBTOTAL (9,RANGE) I just need to know how to count names in a dynamic way. Any insights?
How can we count the total number of rows/ products in "Product name" and also for the count to change every time a filter is used.
So for ex - In table below If I filter out P1 then I want total to show "3" and if filter nothing, total becomes back to "4"
I have found out how to count number in a dynamic way using =SUBTOTAL (9,RANGE) I just need to know how to count names in a dynamic way. Any insights?
Product name | qty |
P1 | 1 |
P2 | 1 |
P3 | 1 |
P4 | 1 |