STDEV of visible cells in a column

[Guest]

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

I using office 2003

Thanks
Daniel

 

[Peo Sjoblom]

SUBTOTAL once again, look it up in help

SUBTOTAL(107,D)



--


Regards,


Peo Sjoblom

 

[Pete_UK]

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

Pete

 

[Guest]

Thanks Peo

SUBTOTAL once again, look it up in help

SUBTOTAL(107,D)



--


Regards,


Peo Sjoblom