Forum Discussion
Solved
Sum
Is there a way to get the sum value for number ranges for example calculating income for James $21,000 - $26,000, Mary $15,000 - $20,000, and Mark $50,000 - $55,000. I want to add these income ranges...
It sounds like the cells with the amounts are text. I recommend arranging the data like this to simplify things:
This is unlikely to be the best solution for you, but there is a trick that allows number ranges separated with minus (hyphen) to be broken apart.
"Lower values"
= IMREAL(range&"i")
"Upper values"
= -IMAGINARY(range&"i")First, however, you would need to strip out the dollar signs since they stop the strings being recognised as numbers.