| 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. |
| 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 | |||
Threaded Mode
