Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not possible.
Maybe you could create a macro that you could assign to a shortcut key: Option Explicit Sub ShowStats() Dim myRng As Range Dim myMin As Variant Dim myMax As Variant Dim myAve As Variant Dim mySum As Variant Set myRng = Selection With Application myMin = .Min(myRng) myMax = .Max(myRng) myAve = .Average(myRng) mySum = .Sum(myRng) End With If IsError(myMin) Then myMin = "--" If IsError(myMax) Then myMax = "--" If IsError(myAve) Then myAve = "--" If IsError(mySum) Then mySum = "--" MsgBox "Min: " & myMin & vbLf & _ "Max: " & myMax & vbLf & _ "Ave: " & myAve & vbLf & _ "Sum: " & mySum End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm WeyburnWaterOperators wrote: How can you have the Excel Status Bar simultaneously display Sum, Average, Max & Min of highlighted data ? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |