If the TRUE in column L is the Boolean TRUE just remove the quotes:
=STDEV(IF($G$2:$G$42="thin",IF($L$2:$L$42=TRUE,$K$2:$K$42)))
Still array entered.
If the TRUE in column L is the Boolean TRUE just remove the quotes:
=STDEV(IF($G$2:$G$42="thin",IF($L$2:$L$42=TRUE,$K$2:$K$42)))
Still array entered.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks