adding numbers that contain ranges
 

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.

adding numbers that contain ranges
 

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.

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.

adding numbers that contain ranges
 

Try this solution

=SUM(A:A,IF(ISNUMBER(FIND("-",A1:A100)),--LEFT(A1:A100,FIND("-",A1:A100)-1))
)&"-"&
SUM(A:A,IF(ISNUMBER(FIND("-",A1:A100)),--MID(A1:A100,FIND("-",A1:A100)+1,15)
))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Fyrfytr" wrote in message
...
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.