| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple values
I need to sum up the qty shipped of each part # for each mth
I have tryed SUMIF, SUMPRODUCT, and DSUM I can not get them to work I would like the formula to look for the maching number in cell a2 (part #) and add the qtys in tab "SCRAP" (c3:c9000) only if it was shipped on B1 (mth) Can some one please help here are some that I have tried =SUMPRODUCT((A2=CellVal1)*(B1=CellVal2)*(Scrap!D3: D9000)) =SUMIF(Scrap!$B$3:$C$9000,$A2,B1,Scrap!$C$3:$C$900 0) thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| multiple series of values graphed with indep. x values -possible? | Charts and Charting in Excel | |||
| How to calculate values in multiple values with multi conditions | Excel Worksheet Functions | |||
Threaded Mode
