Filtered Statistics

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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?
 
Subtotal takes into account filtered data. Check out the help on it and
you'll see how to use it in your case, 7 and 107 find standard deviation. The
formula will be similar to:
=SUBTOTAL(107,'Graph Data'!$R$2:$R$1000)
 
Thanks John
Works great

John Bundy said:
Subtotal takes into account filtered data. Check out the help on it and
you'll see how to use it in your case, 7 and 107 find standard deviation. The
formula will be similar to:
=SUBTOTAL(107,'Graph Data'!$R$2:$R$1000)
Click to expand...
 
Back
Top