Hi everyone,

I'm wondering if someone can help me with one of my formulas.

I am looking to calculate the standard deviation for the values in column K2:K42, only if the values in column G2:G42 say "thin" AND if the values in column L2:L42 say "TRUE".

I tried the below formula:

=STDEV(IF($G$2:$G$42="thin",IF($L$2:$L$42="TRUE",$K$2:$K$42)))
I followed this with Shift+Cntrl+Enter, and I keep coming up with #DIV/0! error.

If anyone can help with this, that would be great! I've been working on this formula for a while now to no avail.

Lauren