How can I count the number of summed
sequential numbers in a single cell until a target is reached
Cell 111111555556112222222222
How can I count the number of summed
sequential numbers in a single cell until a target is reached
Cell 111111555556112222222222
Last edited by philipswaby; 08-10-2018 at 03:09 PM.
So you want to sum individual digits until a set limit is met?
ex. Cell 111111555556112222222222
1+1=2
2+1=3
3+1=4
or
It searches through the call value as a string and once a different digit appears, it sums them?
First digit= 1
*Searching
Next (new) digit = 5
1+5 = 6
*Searching...
Last edited by Xer2; 08-10-2018 at 03:15 PM.
Click on the * icon if this post has been helpful.
1+1=2
2+1=3
=match(false,e2>=mmult(--(row(indirect("1:"&b2))>=transpose(row(indirect("1:"&b2)))),--mid(a2,row(indirect("1:"&b2)),1)),-1) cse
Another way to add
=SUM(1*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) CTRL + SHIFT + ENTER
OR
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
Decio
Last edited by deciog; 08-16-2018 at 08:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks