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
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