Forum Discussion

Copper Contributor

Feb 07, 2025

Solved

STDEV with IF condition using dynamic array

If I insert an array inside SUMIF, it becomes an array formula where it extends itself up to the full range of the data. I want similar thing when using stdev with if condition where the condition is...

Formulas and Functions

office 365

Steve_SumProductCom
Feb 11, 2025
I don't know if I understood correctly, but this may do the trick. Use a FILTER formula to filter the values and then use STDEV on that range. In my example, I filter A1:A10 depending on the value in column B, and then do stdev on D1#. You don't need to display the values in column D. You could just put the STDEV around the FILTER function, such as =STDEV.P(FILTER(A1:A10,B1:B10)).

Steve_SumProductCom

MVP

Feb 11, 2025

I don't know if I understood correctly, but this may do the trick. Use a FILTER formula to filter the values and then use STDEV on that range. In my example, I filter A1:A10 depending on the value in column B, and then do stdev on D1#. You don't need to display the values in column D. You could just put the STDEV around the FILTER function, such as =STDEV.P(FILTER(A1:A10,B1:B10)).