#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 |
#2
|
||||
|
||||
Hi Sandy,
Excel doesn't currently have the equivalent of a STDEVIFS() function, so you would either have to use a helper column or an array formula to get the same effect. For example, if you have these values in F4:G9 Code:
a 1 a 3 b 4 a 5 a 6 Code:
=STDEV(IF(F4:F8="a",G4:G8)) Code:
=STDEV(G4,G5,G7,G8) |
#3
|
|||
|
|||
great! it works and thanks.
|
#4
|
|||
|
|||
stdevifs with date range selection
Awesome! This is so cool.
Two more questions if you or anyone can help out please: 1. multiple conditions and if I can use AND formula like this =STDEV(IF(AND(LOGICAL1, LOGICAL2...) 2 select a date range in M200:M500 if the date is bigger than 11/1 and smaller than 12/1 Thanks so much. |
Thread Tools | |
Display Modes | |
|
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 |