Try
=SUM(IF(LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},"")),1))
confirmed with CTRL+SHIFT+ENTER not just ENTER...
change A1 to actual cell reference first.
Try
=SUM(IF(LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},"")),1))
confirmed with CTRL+SHIFT+ENTER not just ENTER...
change A1 to actual cell reference first.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks