Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistics - p value | Excel Worksheet Functions | |||
Statistics | Excel Discussion (Misc queries) | |||
Statistics | Excel Discussion (Misc queries) | |||
Need statistics help! | Excel Worksheet Functions | |||
p-value, statistics | Excel Discussion (Misc queries) |