多个值同一行 COUNTIF
我有一张如下的乐器选角表(标题Song Casting) 以下是 MWE: +--------+------+--------+-------+------+--------+---------+ | Song | Bass | Guitar | Drums | Keys | Vocals | Back Up | +--------+------+--------+-------+------+--------+---------+ | Song 1 | A8 | A9 | A10 | A11 | A12 | A11 ...