| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does SUMIF in Excel, take multiple criteria input?
I am trying to SUM by month, what is spent on different products or buckets.
The formula I have been trying to make work is: '=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) whe RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40. CRITERIA=(AND(MONTH(1),G3)) SUMRANGE=F10:F40 I have tried several others but don't seem to get even close. Thanks Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Sum with multiple (over 2 criteria) | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Sumif - multiple criteria | Excel Discussion (Misc queries) | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
| Multiple Criteria for SUMIF | New Users to Excel | |||
Threaded Mode
