Adding Cells with Formula , Separate Values

[Kaiser Khan]

Hi All
I have cells with numbers. for example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

I would like to learn a formula that would add these all but show as below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]

when I go a click on this cell I want to see the value separately as below:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]=2+3+4+5[/TD]
[/TR]
</tbody>[/TABLE]

Any Ideas please.
Thanks

 

[Joe4]

Let's say that your values are in cells A1-A4.
You could enter the formula:

= A1+A2+A3+A4

But that is the way the formula will appear in that cell.
If you actually want it to look like:

= 2+3+4+5

then you would either need to type it manually like this yourself, or use VBA like this to build that:

Sub MyAddFunction()
    Range("A5").Formula = "=" & Range("A1") & "+" & Range("A2") & "+" & Range("A3") & "+" & Range("A4")
End Sub

However, note if your do it that way, if you change one of the values in A1-A4, it will NOT update the formula automatically (unless you use Event Procedure VBA code). You will need to run the code again.