Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
At the attached excel, i want to count my "codes" in Column A,B,C,D
for ex: if i dont select any code it must return. 317
if i selecet '34A' it must return 7
if i selecet '89Z' it must return 35+60+14+3= 112
thanks a lot
see attached
one easy solution would be to add them all to a single column and then count them. Would that be helpful for you?
you can think it as a single column but what is the formula to count
Vincent helped me to use
Sum( SubStringCount
( DS_DELAY_SUB_CODE_1&'|'&DS_DELAY_SUB_CODE_2&'|'&DS_DELAY_SUB_CODE_3&'|'&DS_DELAY_SUB_CODE_4,
Kod ))
this formula.But this time when i select '1A' it counts '1A' and '11A'
and '21A' buy all of these three are different
see attached