Forum Discussion
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
Yes
=SUM(FILTERXML("<y><z>"&SUBSTITUTE(A1,",","</z><z>")&"</z></y>","//z"))=SUM(FILTERXML("<y><z>"&SUBSTITUTE(A1,",","</z><z>")&"</z></y>","//z"))