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