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?

Filtered Statistics
 

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)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Steve" wrote:

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?

Filtered Statistics
 

Thanks John
Works great

"John Bundy" wrote:

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)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Steve" wrote:

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?