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