adding numbers that contain ranges
I would like to add a cell containing "$300" with a cell containing
"$800-$1000" and have the cell containing the "sum" function show
"$1100-$1400". Is this possible?
"Bob Phillips" wrote:
What number would be added in that instance?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Fyrfytr" wrote in message
...
I would like to add a column of numbers, but some of the cells contain a
range ($800 - $1000) in them. Is there a formula / function, or do I need
to
split up the ranges.
|