hi guys..
i am using excel 2003. Every time i select a range containing numbers i have to manually change sum status in status bar to count. i was looking for a vba function that could tell me the sum , count and average of numbers simultaneously. The vba function should also work on filtered rows.
Also i was wondering that is there is any way by which after selecting a range a small pop up ( just like which appears on selecting a range telling row and column number) appears automatically which tells the count and sum of selected range???
thanks in advance and sorry for that incomplete post ..
i am using excel 2003. Every time i select a range containing numbers i have to manually change sum status in status bar to count. i was looking for a vba function that could tell me the sum , count and average of numbers simultaneously. The vba function should also work on filtered rows.
Also i was wondering that is there is any way by which after selecting a range a small pop up ( just like which appears on selecting a range telling row and column number) appears automatically which tells the count and sum of selected range???
thanks in advance and sorry for that incomplete post ..