So I have a Column which has multiple texts types in (B1, B2, B3) this corresponds to the group customers are allocated.
Additionally there is another 3 columns which contain yes or blanc cells which tells me if they have received coaching.
I want to filter customers by group and then count how many of them have had coaching.
Im using the following sum to count the group by =SUM(COUNTIFS(E20:E998,{"B1","B2","B3"})) this works and counts the amount of customers i have which are from the B1, B2 or B3 group. But I also want it to count which of these groups have attended coaching which is representative of the text yes in a range of 4 columns.
At the moment I am filtering my tracker to set groups and then using COUNTA acorss the range of 4 columns to get the sum but is there a way to combine COUNTSIFS and COUNTAs so that i can filter customer by group and then count those that have attended coaching ?