Stdevif?

brucey

New Member
Joined
Oct 13, 2010
Messages
5
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!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Try a variation on this array formula

=IF(rng<10,STDEV(rng))

Not sure what 'rng' refers to in this, but won't the IF function only work on one column at a time? The point of AVERAGEIF is that the criteria can be in one column and the value in another.

So my example is month of observation in column A and observation in column B. I can use AVERAGEIF to average all the observations (column B) that are next to the "March" (column A). But the IF function you describe only appears to let me take a STDEV of column B based on the criteria of column B.

Am I making any sense?
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top