Below is a possible solution to the challenge – Challenge 46 – Compute Numerological Sum for a Name
The formula to calculate Numerological Sum for a Name would be –
=MOD(SUMPRODUCT(MOD(CODE(MID(SUBSTITUTE(LOWER(A1)," ",""),
ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1," ","")))),1))+2,9)+1)-1,9)+1
genius, thank u so much for the code. you are so bless with coding talent.
This is lovely!! I was wondering if you have taken this one step further somewhere on your site to give separate totals to vowels and consonants?
I am also wondering if it is possible to show the double digit break down in a different cell…
IE show the value of the double digit in one cell then in a separate cell show the value of the single digit (for both vowels and consonants)?