Forum Discussion
Dan88
Jan 17, 2025Copper Contributor
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!
- JoseDPCopper 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.