Filtered Statistics

[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?

 

[John Bundy]

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)

 

[Steve]

Thanks John
Works great

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)