Solution – Challenge 6 – Non-array Formula for Sum of Square of the Digits in a Numeric String

Posted on July 13, 2015September 7, 2021 by Vijay A. Verma

Below is a possible solution for the challenge – Challenge 6 – Non-array Formula for Sum of Square of the Digits in a Numeric String

=IFERROR(SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)^2),"")

Leave a Reply Cancel reply