Dear teachers ... I want you help in my problem ,how to get sum Result for this 100+200+300 from one Cell ... it must be the Result 600
if you can to change in this Formula
if you can to change in this Formula
Code:
=IFERROR(MID($B2,1,FIND("+",$B2,1)-1)+MID($B2,FIND("+",$B2,1)+1,9^9),$B2)