| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why can't I use the MONTH function within the SUMIFS statement?
I have a Detail worksheet with three named ranges: Category, DateOfService
and Amount. I have a Summary worksheet where I am trying to summaries the amounts by Category (represented by the rows) and Month (represented by the columns). Why do I get an error when I try to use this formula on the Summary sheet? =SUMIFS(Amount,Category,A2,Month(DateOfService),1) where A2 is the first row in the summary data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumifs statemenet returns - , how to use in if statement? | Excel Discussion (Misc queries) | |||
| SUMIFS-time criteria/month | Excel Worksheet Functions | |||
| SUMIFs function | Excel Worksheet Functions | |||
| using sumifs to sum based on month, and criteria | Excel Worksheet Functions | |||
| Can SUMIFS use the OR function? | Excel Worksheet Functions | |||
Threaded Mode
