Results 1 to 3 of 3

SUMIFS function with calculated criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010 & Office 365
    Posts
    13

    SUMIFS function with calculated criteria

    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.
    Last edited by RollsWRangler; 06-24-2013 at 10:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1