See screenshot: Note: For counting cells containing both substrings, you can apply this formula =COUNTIFS(A1:A16,"*Anne ...
確定! 回上一頁