| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct by criteria, month, & year
Column B = mmm/yy
Column C = Quanitity Column D = Criteria (nameA, nameB) I would like to sum column C for all quantities which match citeria in D (nameA) for a certain month and year (Dec, 2007). I tried unsuccessfully to use an IF statement for column D and a sumproduct for the remainder of the formula criteria. Any assistance would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
| SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
| sumproduct for month and year | Excel Discussion (Misc queries) | |||
| how can I highlight a cell if it meets year and month criteria | Excel Worksheet Functions | |||
| Counting distinct entries based on meeting month & year criteria | Excel Worksheet Functions | |||
Threaded Mode
