Cell value = cell. selected ??? pls help

[marcusbox]

Hello all,



When I select a range of cells, my desire outcome is to get a total value quickly. As I can see result from status bar on the lower right hand corner.
Let's say the cell "A1" is the target cell. How can I set the value of Cell "A1" according to the total value of the range of cell that I selected? Any help is very much appreciated. thanks

 

[WarPigl3t]

What?

 

[marcusbox]

Hi WarPiglet,

I want to display the total value of my selected range in cell "A1" how can I do it? thanks

 

[Teeroy]

If you are planning in advance just use the sum function.
A1: =sum(selection)

If you want this to occur on the fly you'll probably need a macro. A simple code to do it is, in a standard code module:

Sub SumSelection()
Range("a1").Value = WorksheetFunction.Sum(Selection)
End Sub

Set the macro to fire on a shortcut keystroke e.g. CTRL+S

 

[WarPigl3t]

I like what teeroy did, but you can also use a msgbox
MsgBox application.worksheetfunction.sum(selection)

 

[marcusbox]

If you are planning in advance just use the sum function.
A1: =sum(selection)

If you want this to occur on the fly you'll probably need a macro. A simple code to do it is, in a standard code module:

Sub SumSelection()
Range("a1").Value = WorksheetFunction.Sum(Selection)
End Sub

Set the macro to fire on a shortcut keystroke e.g. CTRL+S

Nice! It's simple and very straight forward, thanks!

 

[Teeroy]

You're welcome.