Average of cells in a column
If the cells are hidden manually or by filtering and you have XL 2003 you can
use the SUBTOTAL function.
=SUBTOTAL(101,A:A)
If you have XL 2002 or earlier and rows are hidden by filter use this one
=SUBTOTAL(1,A:A)
Gord Dibben MS Excel MVP
On Wed, 24 Oct 2007 14:40:01 -0700, Daniel
wrote:
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
|