excel - Can a countifs do this or do I need an array? -

excel - Can a countifs do this or do I need an array? -

i have info range b5:l100. in column b string identifier, 'x' or 'y'. in columns c:l have different people's names entered (never more 1 time per row).

i want count how many times person's name appears in rows column b 'x'. next formula doesn't work (using "max" illustration person search for). can advise on elegantly?

=countifs(c5:l100,"max",b5:b100,"x")

i think array formula might in order, i'm not experienced on those.

=sumproduct((c5:l100="max")*(b5:b100="x"))

excel excel-formula