Sum a range of cells which include concatenated values
Posted on 2014-12-30
I have a vertical range of values. Each cell concatenates a number and a string. For example (=C2&C3) where C2 = 30 and C3 = SomeText. The result value of the cell would be 30SomeText.
I realize that the concatenate formula turns this into a string and it is no longer a number that cam be calculated. But I am wondering if there is some way around this. I want to look at the range and add all the numbers that have the same text.
For example, if this was my range of cells.
I want to look at that range, find the "SomeText2" values, and add the numbers which in this case would result in a 100.