field count

[#1]

     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

[giakoum]

one easy solution would be to add them all to a single column and then count them. Would that be helpful for you?

[#3]

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

[giakoum · Accepted solution]

see attached