Forum Discussion
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 a list of values present in a column.
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)).
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)).
