Saurabh Jain Posted September 29, 2022 Share 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 Link to comment Share on other sites More sharing options...
RVG Posted September 30, 2022 Share Posted September 30, 2022 =SUMPRODUCT(ROUNDDOWN(ROUNDUP(MOD(A1/10^(ROW(A1:A10)),1),5)*10,0)) 1 Quote Link to comment Share on other sites More sharing options...
Rasha Gouda Posted October 1, 2022 Share Posted October 1, 2022 Can we post challenges that reflect the real business scenarios, a lot are complicated out there! Quote Link to comment Share on other sites More sharing options...
Saurabh Jain Posted October 2, 2022 Author Share 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 Link to comment Share on other sites More sharing options...
Mbuyiselo Ntandoyenkosi Xaba Posted October 2, 2022 Share 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 Link to comment Share on other sites More sharing options...
Philippe Gilliard Posted October 4, 2022 Share Posted October 4, 2022 =BYROW(VALUE(MID(A1;SEQUENCE(;LEN(A1));1));LAMBDA(lrow;SUM(lrow))) Quote Link to comment Share on other sites More sharing options...
Dheeraj Vaid Posted October 27, 2022 Share Posted October 27, 2022 =SUM(NUMBERVALUE(MID(A1,SEQUENCE(LEN(A1)),1))) Quote Link to comment Share on other sites More sharing options...
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.