Standard Deviation With Conditions

[avd88]

Hi,

I have a dataset with about 5 different groups where I need to get the standard deviation of each one of the groups.
I was trying a formula like the one below, I wasn't expecting it to work to be honest and it didn't. In the case below I'm basically trying to get the standard deviation for AM and SBM:

=ROUND(STDEV.P(IF(OR('Q3 2020'!A:A = "AM",'Q3 2020'!A:A="SBM"),'Q3 2020'!F2:F235,"")),2)

Any ideas of the most efficient way to calculate this?

Thank you!

 

[Phuoc]

=ROUND(STDEV.P(IF(('Q3 2020'!A:A = "AM")+('Q3 2020'!A:A="SBM"),'Q3 2020'!F2:F235,"")),2)

Enter with Ctrl+Shift+Enter

 

[avd88]

Thanks for your response.

I tried your formula and it sort of works. The actual standard deviation should be $6,630 and your formula gives me $6,761.
Do you know where the difference comes from?