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:
The result is pretty crazy, but it works
= LET(
string, SUBSTITUTE(range, "$", "") & "i",
lower, IMREAL(string),
upper, -IMAGINARY(string),
CONCATENATE(TEXT(SUM(lower),"$#,##0"), "-", TEXT(SUM(upper),"$#,##0"))
)