Hey,

This is my first post so I hope I am doing everything alright. I am trying to find the standard deviation for a range of cells that meet 4 conditions. Here is what I am trying, and I have used CSE and simply enter:

=STDEV.P(IF(AND($AO$10:$AO$1030<BB$7,$AO$10:$AO$1030>BA$7,$AW$10:$AW$1030<$BA8,$AW$10:$AW$1030>$BA7),$D$10:$D$1030))

Basically, if it a value in AO is between two numbers and a value in AW is between two numbers, then I want the corresponding cell (same row) in column D to be included in that group. And I then want the stdev.p of that group of numbers.

I also know that the conditions ARE being met because I did a countifs and an averageifs with the same conditions and it worked.

Can somebody help me with this one??

Thanks!