SUMIF for texts
Could anyone help me with this?
I want to create a reference on text (like a SUMIF, but for text)
input: different persons get "x" on CL01, CL02,...
output via formula: OP1,OP2,OP3 listing the column with "x"
A B C D H I J
1 CL01 CL02 CL03 OP1 OP2 OP3
2 John x CL01 - -
3 Hugues x x CL02 CL03 -
|