Forum Discussion

Shailesh1982's avatar
Shailesh1982
Copper Contributor
Jul 23, 2021

Formula

I have two no in one cell and i want addition of that two no in another cell which formula I have to use please guide
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2021

Shailesh1982 

As a comment, formula suggested by Detlef_Lewin is more flexible and could count any reasonable number of numbers within cell.

To expand PeterBartholomew1 formula as variant

=LET(input, A1, sep, ",",
   seps,  LEN(input)-LEN(SUBSTITUTE(input,sep,"")),
   k,     SEQUENCE(seps+1),
   start, IFERROR( FIND("|",SUBSTITUTE(input, sep,"|",k-1))+1,1),
   end,   IFERROR( FIND("|",SUBSTITUTE(input, sep,"|",k)),LEN(input)+1),
   SUM(--TRIM(MID(input, start, end-start)))
)

Resources