Hi all,
So AVERAGEIF has been very nicely explained to me at, and its a incredibly useful functions.
The averages I've taken from my dataset I then want to know their standard deviation. There doesn't seem to be, though, an equivalent function for standard deviation (STDEVIF if you will).
Can anyone suggest a function or a formulaic work-around that would allow me to get standard deviations of averages taken from AVERAGEIF.
Thanks!
So AVERAGEIF has been very nicely explained to me at, and its a incredibly useful functions.
The averages I've taken from my dataset I then want to know their standard deviation. There doesn't seem to be, though, an equivalent function for standard deviation (STDEVIF if you will).
Can anyone suggest a function or a formulaic work-around that would allow me to get standard deviations of averages taken from AVERAGEIF.
Thanks!