Currently Being ModeratedJan 14, 2013 4:07 AM (in response to Sirolway)
The reason your first scheme fails is that the sub-expression "MONTH(January 2013 :: Date)" returns a Value, whereas the function SUMIFS is looking for a a cell range Address specification. While I admit to not having checked, I suppose that all the compatible spreadsheets out there would have the same issue with your approach.
The alternative is to have an additional condition pair in your Sumifs expression. Specify that the date of the records be Greater than or equal to the first day of the month in question AND less than the first day of the next month. Specifying the end of the range is what takes the additional condition.
You can calculate the first day of the next month with the expression: EOMONTH(date) + 1, where date is any day in the current month.
Currently Being ModeratedJan 16, 2013 7:22 PM (in response to Jerrold Green1)
The expression that I wrote about, EOMONTH, should have included the Month Offset argument. I assume that you looked up the syntax before using, but I should have written:
You can calculate the first day of the next month with the expression: EOMONTH(date, 0) + 1, where date is any day in the current month.
Currently Being ModeratedJan 17, 2013 12:16 AM (in response to Jerrold Green1)
Yes - Google is my friend so I'd found the syntax.
I've got my expression doing what I want now so all is good - thanks for your help
Currently Being ModeratedJan 17, 2013 5:42 AM (in response to Sirolway)
You can get function help from within Numbers by using View > Show Function Browser.