Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
Question about STDEVP on PIVOT TABLE..... | Excel Discussion (Misc queries) | |||
Should I use STDEVP | Excel Worksheet Functions | |||
How many std deviations is Excel function "STDEVP" | Excel Worksheet Functions | |||
Array Function | Excel Worksheet Functions |