I'm trying to extend the range of the SUMIFS( ) function criteria field. I could type in "01/31/2013" which would evaluate to TRUE if one of the records in the criteria field was this exact date. What I want is a month-end date (using the eomonth function) so that any date in the range 01/01/2013 through 01/31/2013 would evaluate to 01/31/2013. What I do not want to do is to have to create a dalculate column in the data and use that as a criteria range. I want to use d variable parameter in one step via the SUMIFS( ) function.
Bookmarks