Excel 2003 Status Bar Calculations

G

Guest

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

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top