Posted to microsoft.public.excel.misc

Steve

external usenet poster

Posts: 1,814

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Statistics - p value	psipg	Excel Worksheet Functions	3	June 14th 08 12:21 PM
Statistics	Mike H.	Excel Discussion (Misc queries)	4	October 25th 07 12:28 PM
Statistics	bebec20	Excel Discussion (Misc queries)	2	January 18th 07 05:46 PM
Need statistics help!	Pizza	Excel Worksheet Functions	5	January 10th 07 10:05 PM
p-value, statistics	wim rademakers	Excel Discussion (Misc queries)	1	January 18th 06 02:23 AM

All times are GMT +1. The time now is 09:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us