STDEVP function with an array

[Neil]

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.

 

[Barb Reinhardt]

IIRC, I've not been able to use AND when I do things like this. You need
to nest the IFs

 

[Neil]

Thanks for the help, Barb. That worked perfectly.