I am trying to build a formula that performs the COUNTIF (or COUNTIFS) based on criteria of one column, and then an array of multiple columns.
"A" "B" "C" "D" "E" "F"
1 Site QA1 QA2 QA3 QA4 QA5
2 IN Rude Transfer Dial Transfer
3 IN Transfer EPIC Rude
4 SD EPIC Dial
5 CR EPIC Dial Transfer Wait Rude
6 SD Transfer EPIC
7 SD Rude Wait
8 CR Transfer
9 MI Dial


I am then wanting to populate the results in a table based on the data above in a fashion similar to this:

IN SD CR MI
Rude 2 1 1 0
Transfer 3 1 2 0
EPIC 1 2 1 0
Dial 1 1 1 1
Wait 0 1 1 0

I have tried MANY different formulas. IF functions, COUNTIFS, ORs...nothing seems to return the results I want once I need to include IF (A:A = "IN) and (B:B = 'RUDE' OR C:C = 'RUDE' OR D:D = 'RUDE' OE E:E = 'RUDE' OR F:F = 'RUDE') then count occurrences.

=IF(OR($B$2:$B$9=$A$14, $C$2:$C$9=$A$14, $D$2:$D$9=$A$14, $E$2:$E$9=$A$14, $F$2:$F$9=$A$14), COUNTIF($A$2:$A$9, "="&B$13))
=COUNTIFS($A$2:$A$9, "="&$I$7, $B$2:$F$9, "="&$H$8)

I can get it to work if I just need A AND B, but once I need A and (B or C or D or E or F) it fails or errors out.