John Gibbons
New Member
Good day Chandoo family
The attached file contains a table with two slicers. Problem: How many items (count) based on slicer selection(s)?
Using the CountA function provides a number; however, the number doesn't change based on the slicer selection(s). If possible, I would like to avoid using a pivot table or VBA. I would appreciate any assistance on this problem.
Thank you very much.
The attached file contains a table with two slicers. Problem: How many items (count) based on slicer selection(s)?
Using the CountA function provides a number; however, the number doesn't change based on the slicer selection(s). If possible, I would like to avoid using a pivot table or VBA. I would appreciate any assistance on this problem.
Thank you very much.