• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the result of adding several numbers into one cell with a plus sign (+)

Hany ali

Active Member
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
Code:
=IFERROR(MID($B2,1,FIND("+",$B2,1)-1)+MID($B2,FIND("+",$B2,1)+1,9^9),$B2)
 

Attachments

Hany ali

Active Member
Well done, my dear teacher, and he is really required
Thank you very much ... To you, Muna, all the greetings and respect, and may God bless you
thanks
@pecoflyer ,but I cant Used this because i work in Excel 2010 ,and this formula EVALUATE ,Not Define !!
 
Last edited:
Top