How to add a range of Values in a single cell

[BigDaddyRod]

Hello.

I came up across a problem: I want to add a range of values in a single cell but cannot seem to find a solution for this.
For example:

In cell A1 I want to write 1-12 and in cell B1 I want to write 25-28.
A1 B1
2-13 25-28


Now, I need the answer to A1 to be 12 and the answer to B1 to be 4, so the total value of both cells be 16.

How can I do this?

 

[BigDaddyRod]

Sorry, I tried to edit the thread but I do cannot seem to find the EDIT function, let me rephrase what I wanted:

In cell A1 I want to write 2-13 and in cell B1 I want to write 25-28.
A1 - B1
2-13 - 25-28


Now, what I need is that the answer to A1 be 12 (the range of numbers between 2 and 13) and the answer to B1 be 4 (range between 25-28), so the final sum of the 2 cells be 12+4 = 16.

Is there a way to do this?

 

[Fluff]

Hi & welcome to MrExcel
A cell can EITHER contain a value OR a formula, but not both.
You will either need to use another cell, or VBA.

 

[BigDaddyRod]

Oh, I see.
Then how can I add a range of numbers in a single cell like I showed before?

A1
2-13

The sum must be 12.

 

[Fluff]

In A2 put
=ABS(LEFT(A1,FIND("-",A1)-1)-RIGHT(A1,LEN(A1)-FIND("-",A1)))+1

 

[BigDaddyRod]

Thank you very much Fluff, that will help me a lot.

 

[Fluff]

You're welcome