STDEV of visible cells in a column
 

How can I write a function to calculate
standard deviation of visible cells in a column
normally I wrote: STDEV (D:D)
but this will calculate all cells

I using office 2003

Thanks
Daniel

STDEV of visible cells in a column
 

SUBTOTAL once again, look it up in help

SUBTOTAL(107,D:D)



--


Regards,


Peo Sjoblom


"Daniel" wrote in message
...
How can I write a function to calculate
standard deviation of visible cells in a column
normally I wrote: STDEV (D:D)
but this will calculate all cells

I using office 2003

Thanks
Daniel

STDEV of visible cells in a column
 

I guess some people just don't like clicking on Help, Peo. <bg

Pete

On Oct 24, 11:25 pm, "Peo Sjoblom" wrote:
SUBTOTAL once again, look it up in help

SUBTOTAL(107,D:D)

--

Regards,

Peo Sjoblom

"Daniel" wrote in message

...



How can I write a function to calculate
standard deviation of visible cells in a column
normally I wrote: STDEV (D:D)
but this will calculate all cells

I using office 2003

Thanks
Daniel- Hide quoted text -

- Show quoted text -

STDEV of visible cells in a column
 

Thanks Peo

"Peo Sjoblom" wrote:

SUBTOTAL once again, look it up in help

SUBTOTAL(107,D:D)



--


Regards,


Peo Sjoblom


"Daniel" wrote in message
...
How can I write a function to calculate
standard deviation of visible cells in a column
normally I wrote: STDEV (D:D)
but this will calculate all cells

I using office 2003

Thanks
Daniel