Forum Discussion

Dan88's avatar
Dan88
Copper Contributor
Jan 17, 2025

Excel Sum

Hello to all the community!

Excuse me if I make a question for a so simple problem, but I cannot resolve it by myself.

I have a list of cells with values like 10 + 1, 6 + 1, 5 + 2 etc...

A                B

               10 + 1

                 5 + 1

                 6 + 1

                 TOTAL

I would like to sum them, but it is like Excel does not recognize them as values, because of the "+". There is some way to do it?

Thank you very much!

 

  • JoseDP's avatar
    JoseDP
    Copper Contributor

    Try using the below formula:
    SUM(TEXTSPLIT(TEXTJOIN("+", ,A1:A3),"+") + 0)

    Assuming your values 10 + 1, 5 + 1, and 6 + 1 are in A1, A2 and A3 respectively.

     

  • Why don't you enter the values 10, 1, etc. in separate cells? You can then use the SUM function without problems.

Resources