Thread
:
Average of cells in a column
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Average of cells in a column
Perhaps you should look in the help index for SUBTOTAL. Or, try the formula
presented
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Daniel" wrote in message
...
Hi Peo
Is SUBTOTAL calculate the sum ? but I need to calculate average
Thnks
Daniel
"Peo Sjoblom" wrote:
What version of Excel are you using? If 2003 and later you can use
=SUBTOTAL(101,D:D)
will only average visible cells
in earlier versions you would need a VBA function
--
Regards,
Peo Sjoblom
"Daniel" wrote in message
...
what I meant is average of visible cells only.
Average(D:D) will caculate all cells
Daniel
"Daniel" wrote:
Hi
How can I write a function Average of cells in a column but not count
hiden
cells?
Normally I write: Average(D:D) but this function will calculate
average
all
cells even hiden cells
In my spread sheet I have some hiden cells such as below
Cell in row 1
2
3
4
100
101
102
....
i just want to calculate average of cell 1,2,3,4,100,101,102 but skip
cells
in row 5 to 99
Thanks
Daniel
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett