| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criteria
I'm trying to create a formula to seach multiple columns with multiple
criteria. I'm currently using the following formula: =SUMPRODUCT(--('BOM LIST'!$J$8:$J$770=B31),--('BOM LIST'!$A$8:$A$770={"S","S-FED","O"}),--('BOM LIST'!$G$8:$G$770={"F","Q","R"}),'BOM LIST'!$Z$8:$Z$770) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
| Counting by multiple criteria | Excel Worksheet Functions | |||
| Sum Multiple Criteria or DcountA | Excel Worksheet Functions | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Linear Mode
