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?
As a comment, for "2DD_" it counts D in it as 1, shall be 2.
Thank you. I've updated my post.
Another approach would be to table the data and use 3 COUNTIFs. Possible drawbacks: increased workbook size with the table and possibly slower calculation time? I don't have a vba timer at the moment.