numbers not adding up

[bigdan]

i'm sure that subject line was useless but i couldnt come up with anything better.

given a set of numbers in excel, if you were to highlight them, you'd see the sum in the bottom of the screen. this would be without any formulas or anything. (before i go on, what's that screen / value called?). lately that's not happening for me though. if i were to highlight 4 numbers instead of giving the sum it'll say countNum=4 or something like that. huh???

as an aside, can i program this "number" to give me something else, like the average of all the numbers highlighted? or can i have two different things, one giving me the sum, one giving me the average?

 

[repairman615]

Hello,

Unless I am misunderstanding that area down there is the Status Bar.

Right click it to open up all kinds of possibilities.

 

[bigdan]

ahhh that did it!

is there any way to have more than one calculation appear in the status bar? it seems restricted to one?
this is excel 03 btw.

on an unrelated note would installing 07 / 2010 work as fast on my computer or would it slow things down? im already fairly sluggish.

 

[repairman615]

Not any way I know to do a custom, yet that still may be possible... that would be way beyond my current knowledge.

I am using;

Average, Count, Min, Max, and Sum.

2007

 

[repairman615]

I like 2007, I will go upgrade one day. I am not a user by profession. I just really like Excel.

I would guess 2007 or later would run as fast, if not faster than 2003.

IMO, if you can, go for a more recent version. The IFFERROR() function alone is worth it.

-Jeff

 

[bigdan]

you said you're using min, max, sum etc.

what, at the same time? it seems you can only use one at a time no?

 

[repairman615]

Yes, At the same time. I can not remember exactly what it was like in 2003. May only be one.

In 2007 you can choose some or all while in the right click menu.


I have not had the pleasure of 2010 yet. I heard it will do all of that plus make coffee.

 

[Michael M]

Hey Jeff
Yep, same in 03....one at a time, unless some expert has come up with a way 'round it !!

 

[repairman615]

Hey Jeff
Yep, same in 03....one at a time, unless some expert has come up with a way 'round it !!

Hello Michael,

I think the 'Easy' solution is to upgrade.. ---
After using 2007, I think I would be bummed to go back.

Looking back, I remember upgrading from 97 to 2003 and thought 2003 was the cats meow.

 

[njimack]

A workaround for XL03 (you would have to paste this into each sheet module):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str  As String
If WorksheetFunction.CountA(Selection) = 0 Then
    Application.StatusBar = False
    Exit Sub
End If
Application.EnableEvents = False
str = "SUM: " & WorksheetFunction.Sum(Selection)
str = str & " MAX: " & WorksheetFunction.Max(Selection)
str = str & " MIN: " & WorksheetFunction.Min(Selection)
str = str & " AVG: " & WorksheetFunction.Average(Selection)

Application.StatusBar = str
Application.EnableEvents = True
    
End Sub