| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Multiple Criteria
I've been reading some of the postings and trying to create a formula that
adds from one column based on multiple criteria: =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) What am I doing wrong? Also, can anyone reccommend a book on how to increase my knowledge of such formulas? |
| 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) | |||
Threaded Mode
