## Solution - Challenge 46 – Compute Numerological Sum for a Name

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