#1
|
|||
|
|||
similar formula of averageifs() like for standard deviation
I used averageifs() to conditionally select scattered cells in a column to calculate a mean given the cell meet certain criteria. I need also to calculate the standard deviation of these same selected cells. I would expect the excel may have a similar formula something like: stdevifs(). Do anyone knows anything like this? or how to get around to calculate a standard deviation with the same selected cells?
appreciate for any comments or answers. sandy |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comment in Word similar to Excel | eradem | Word | 3 | 10-01-2011 11:54 AM |
How to set standard format for all | TDV | Word | 0 | 07-02-2011 09:41 PM |
How do you create a list similar to an itunes list? | hatemail13 | Excel | 1 | 08-06-2010 02:21 AM |
deviation | RolandVet | Excel | 0 | 04-18-2010 12:38 AM |
[Office]How to create project timeline similar to this? | Coderedpl | Project | 0 | 09-11-2009 01:23 PM |