tag:blogger.com,1999:blog-7958828565254404797.post7192381501526634900..comments2024-03-29T00:02:14.892-07:00Comments on ListenData: Excel: 4 Ways to Sum Digits in a NumberDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7958828565254404797.post-77252472006076648722019-02-22T02:04:35.605-08:002019-02-22T02:04:35.605-08:00THE FORMULAS WONT WORK FOR CELL WITH LINE BREAKS N...THE FORMULAS WONT WORK FOR CELL WITH LINE BREAKS NUMBER VALUEAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-5746558945746909422016-11-06T00:08:20.243-07:002016-11-06T00:08:20.243-07:00There is one more.
ctrl+shift+enter:
=SUM(IFERROR(...There is one more.<br />ctrl+shift+enter:<br />=SUM(IFERROR(1*MID(B4,ROW($1:$99),1),))<br />Anonymoushttps://www.blogger.com/profile/06413886937768866287noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-69670641922003159242015-04-20T05:38:38.946-07:002015-04-20T05:38:38.946-07:00plz explain itplz explain ityuvrajhttps://www.blogger.com/profile/04198589646006716865noreply@blogger.com