Standard deviation and if function

[Veronika_T]

Hello,
I have a big set of data with various characteristics. I need to calculate average and stdev of a subset belonging to particular group. I used "averageif" function - worked perfectly - and am looking for something like"stdevIF" - can someone help me, please?
Thanks in advance,
V.

 

[Aladin Akyurek]

Hello,
I have a big set of data with various characteristics. I need to calculate average and stdev of a subset belonging to particular group. I used "averageif" function - worked perfectly - and am looking for something like"stdevIF" - can someone help me, please?
Thanks in advance,
V.

Control+shift+enter, not just enter:

=STDEV(IF(GroupRange=Group,ValueRange))

 

[Veronika_T]

Wow, it's magic! It worked!
Now, stupid follow-up question: what is this magic combination of "enter+ctrl+shift"?
THANKS!!!!
V.

 

[Aladin Akyurek]

Wow, it's magic! It worked!
Now, stupid follow-up question: what is this magic combination of "enter+ctrl+shift"?
THANKS!!!!
V.

The combination signals Excel that the formula is intended to process arrays.
See Excel's Help under the "array" keyword.

 

[Veronika_T]

Thanks again!
V.

 

[briordan]

But will this work for 2 conditions?

To extend the current example:

=STDEV(IF(GroupRange=Group,ValueRange) might be something like =STDEV(IF(AND(GroupRange1=Group1,GroupRange2=Group2, ValueRange)

All my efforts so far have failed.

Thanks, briordan

 

[Canapone]

Hi,

maybe

=STDEV(IF(GroupRange1=Group1,IF(GroupRange2=Group2,ValueRange)))

to be confirmed with control+shift+enter

Hope it helps

 

[briordan]

Ciao Canapone, funziona bene, grazie mille!

It works, thank you very much.

Ciao,
briordan

 

[Canapone]

Ciao,

thanks for your kind feedback.

Alla prossima