Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array with OR condition and multiple criteria tests
Hello,
I'm trying to find a way to sum the values in a worksheet which lists the costs of parts, for those parts which meet 2 critera. The part costs are in column J, and the criteria which must be met are codes which are in column A; (this is just a simple true/false test referencing a cell in a summary table), and another code in column M, which is an either/or type criteria, (=850, or <600). I've used the conditional sum wizard in the past for this type of application, but the or criteria for the code in column M has me a bit stumped. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array with OR condition and multiple criteria tests
Check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Gubawatts" wrote: Hello, I'm trying to find a way to sum the values in a worksheet which lists the costs of parts, for those parts which meet 2 critera. The part costs are in column J, and the criteria which must be met are codes which are in column A; (this is just a simple true/false test referencing a cell in a summary table), and another code in column M, which is an either/or type criteria, (=850, or <600). I've used the conditional sum wizard in the past for this type of application, but the or criteria for the code in column M has me a bit stumped. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify condition using multiple criteria WITHOUT sumproduct?.. | Excel Discussion (Misc queries) | |||
Dynamic multiple-condition array function with more than one name | Excel Worksheet Functions | |||
array formula count results of two tests | Excel Worksheet Functions | |||
Multiple tests for a condition | Excel Programming | |||
How do I sum an array with multiple condition?? | Excel Worksheet Functions |