Forum Discussion

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

Diamond Contributor

Jul 23, 2021

Is that like this?

Shailesh1982
Copper Contributor
Jul 23, 2021
Yes
- Detlef_Lewin
  Silver Contributor
  Jul 24, 2021
  Shailesh1982
  =SUM(FILTERXML("<y><z>"&SUBSTITUTE(A1,",","</z><z>")&"</z></y>","//z"))
- Riny_van_Eekelen
  Platinum Contributor
  Jul 24, 2021
  Shailesh1982 Inspired by the contributions of PeterBartholomew1 and SergeiBaklan , try this in case Peter's LET formula doesn't work for you:

Resources