Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Status Bar Calculations
How can you have the Excel Status Bar simultaneously display Sum, Average,
Max & Min of highlighted data ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Status Bar Calculations
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Status Bar Calculations
AFAIK you cannot. This is a feature that has been added to Excel 2007.
"WeyburnWaterOperators" wrote: How can you have the Excel Status Bar simultaneously display Sum, Average, Max & Min of highlighted data ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Status Bar Calculations
All you get is one choice from the options.
Gord Dibben MS Excel MVP On Fri, 18 Aug 2006 13:38:02 -0700, WeyburnWaterOperators wrote: How can you have the Excel Status Bar simultaneously display Sum, Average, Max & Min of highlighted data ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |