STDEVP function with an array
 

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.

STDEVP function with an array
 

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

If this post was helpful to you, please click YES below.



"Neil" wrote:

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.

STDEVP function with an array
 

Thanks for the help, Barb. That worked perfectly.

"Barb Reinhardt" wrote:

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

If this post was helpful to you, please click YES below.



"Neil" wrote:

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.