Hi there, I'd like to know how the formula below is equal to the anwer below?
I'm not sure what the Substitute function does in the query below? I know the outer query is an array.
Problem:
Value of G2: 179736
Formula: =SUM((LEN(SUBSTITUTE(G2,{1,2,3,4,5,6,7,8,9},"")))*{1,2,3,4,5,6,7,8,9})
Answer: 237
Bookmarks