Is there a way to use multiple criteria when using the STDEVP function with
an array? If I use a single criterion, the following formula works fine:
{=STDEVP(IF(Names!$F$3:$F$61="B",Names!S$3:S$61))}

When I try multiple criteria, I get 0 as a result, though I know this is
incorrect:
{=STDEVP(IF(AND(Names!$F$3:$F$61="B",Names!$J$3:$J $61<"USD"),Names!S$3:S$61))}

Thanks in advance for any help.