Thanks all, you saved my life
Daniel

"Peo Sjoblom" wrote:

You couldn't even try it before you posted back!!?

Look up SUBTOTAL as a function in help

=SUBTOTAL(101,D:D)

will average

=SUBTOTAL(109,D:D)

will sum


102 is COUNT

103 is COUNTA

104 is MAX

105 is MIN


--


Regards,


Peo Sjoblom



"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