View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Filtered Statistics

I have a spreadsheet with data in columns and calculate statistics like
standard deviation using a formula similar to the below.
=IF(ISBLANK('Graph Data'!$R$3),"",STDEV('Graph Data'!$R$2:$R$1000))

If I apply a filter that eliminates some of the rows of data, the result
from the formula doesn't change. Is there a way to calculate and display the
calculation for the visible rows only?