Saurabh Jain Posted September 29, 2022 Posted September 29, 2022 Write a Formula or vba code or power query to calculate sum of digits All answers posted will be hidden for three days 1 Quote
RVG Posted September 30, 2022 Posted September 30, 2022 =SUMPRODUCT(ROUNDDOWN(ROUNDUP(MOD(A1/10^(ROW(A1:A10)),1),5)*10,0)) 1 Quote
Rasha Gouda Posted October 1, 2022 Posted October 1, 2022 Can we post challenges that reflect the real business scenarios, a lot are complicated out there! Quote
Saurabh Jain Posted October 2, 2022 Author Posted October 2, 2022 19 hours ago, Rasha Gouda said: Can we post challenges that reflect the real business scenarios, a lot are complicated out there! keep connected - we will have more to come .... lets focus on this one ....Do give a try Quote
Mbuyiselo Ntandoyenkosi Xaba Posted October 2, 2022 Posted October 2, 2022 (edited) Assuming the first number 456 is in cell A2 =SUMPRODUCT(MID(A2, ROW(OFFSET(&A$1,,,(LEN(A2))),1)+0) Edited October 2, 2022 by Mbuyiselo Ntandoyenkosi Xaba Quote
Philippe Gilliard Posted October 4, 2022 Posted October 4, 2022 =BYROW(VALUE(MID(A1;SEQUENCE(;LEN(A1));1));LAMBDA(lrow;SUM(lrow))) Quote
Dheeraj Vaid Posted October 27, 2022 Posted October 27, 2022 =SUM(NUMBERVALUE(MID(A1,SEQUENCE(LEN(A1)),1))) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.