Forum Discussion
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 ...
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.