Forum Discussion
How to sum the numbers in a text string?
Hi Could anyone help solve the below-attached problem? Unable to figure the formula to get an answer for the stock mentioned in the attached excel sheet. How can I do that by using the formu...
I'm not sure about what exactly you want to SUM.
From what I see, you give labels and those labels are converted into points of some sort, points that you want to SUM.
I think this can be done with a conversion table and a VLOOKUP to convert those labels into points.
Kind regards
Hans