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:
It sounds like the cells with the amounts are text. I recommend arranging the data like this to simplify things:
Thank you! I separated the ranges and was able to figure the rest out. I appreciate your response.