| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct/sum not working with multiple variables
Correction:
should be "D03", not "DO3" "Nelson" wrote: I am using this formula which works well if I am only trying to match 1 part number D03KHLL =SUMproduct(IF(ISNUMBER(A8:A23),IF((YEAR(A8:A23)=2 009)*(B8:B23="D03KHLL"),L8:L23))) however if I add more part numbers like this =SUM(IF(ISNUMBER(A8:A23),IF((YEAR(A8:A23)=2009)*(B 8:B23="D03KHLL,D03KJLL,D03KILL"),L8:L23))) this does not seem to be working they way I have read this to work both in sum and sumproduct Any suggestions Thanks -- Nelson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SUMPRODUCT, 3 variables, 2 types of data in 1 column | Excel Worksheet Functions | |||
| If,Then for multiple variables. | Excel Discussion (Misc queries) | |||
| sumproduct with 3 variables | Excel Discussion (Misc queries) | |||
| Multiple variables-SOS | Excel Worksheet Functions | |||
| multiple variables in sumproduct or if/then formulas | Excel Worksheet Functions | |||
Threaded Mode
