i use sheets of google docs excel online.

i have value A1 - A6 with value

Column A
ax
ab
ac
ab
x

but formula in excel alawy return = 0.

 =SUM(COUNTIFS(A1:A5;{"axx";"ab"})) // return = 0

link demo