Forum Discussion
Solved
COUNT
Dear Experts, Greetings! In attached file names "COUNT" We have 3 variables "D", "U" and "S" 2DU => means 1 D and 1 U 2SU => means 1 S and 1 U, In the...
=SUMPRODUCT(LEN($A2:$AO2)-LEN(SUBSTITUTE($A2:$AO2,AP$1,"")))Does this return the intended output?
=SUMPRODUCT(LEN($A2:$AO2)-LEN(SUBSTITUTE($A2:$AO2,AP$1,"")))Does this return the intended output?