well the easiest way would be to sum the countifs! or since they all end in d and theres no "d" in active
=COUNTIF(A1:A100,"*d")