Excell : calcukate how many specific word in a list

Use formula
=countif(a:a,"*dcl*")

Above example will count all word "dcl" that available in colom a, whatever the row..., they will sum it all..