Excel 2003 Status Bar Calculations
 

How can you have the Excel Status Bar simultaneously display Sum, Average,
Max & Min of highlighted data ?

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

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 ?

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 ?