Ultimately I want the count of the number of visible rows where the multiple criteria is specified (I don’t want to use Filter for the criteria).
I have numerous sales people with 6 types of sales. I only want to know the count of 3 of the types of sales; i.e., "Red", "Blue", and "Green". I will be using a filter for the names of the sales people. But need a formula for the count of the 3 types of sales. For instance, I want to know that Mary had 3 of the "Red", "Blue", and "Green" types of sales. See uploaded image.
I've tried for hours and can get the total "Red" "Blue" and "Green" sales but my total stays the same when I filter for Mary's name only.
I have numerous sales people with 6 types of sales. I only want to know the count of 3 of the types of sales; i.e., "Red", "Blue", and "Green". I will be using a filter for the names of the sales people. But need a formula for the count of the 3 types of sales. For instance, I want to know that Mary had 3 of the "Red", "Blue", and "Green" types of sales. See uploaded image.
I've tried for hours and can get the total "Red" "Blue" and "Green" sales but my total stays the same when I filter for Mary's name only.