View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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