+ Reply to Thread
Results 1 to 2 of 2

SUMIFS with "array OR" and cell reference

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    75

    SUMIFS with "array OR" and cell reference

    Hi all. Been a while since I was on here but hoping someone can help me tackle this.

    I have data than I would like the sum of revenues for in a chart based on if it matches a customer name and falls within one of three months. I have done this successfully by manually entering the months into the array portion of my sum+sumifs formula, but I would like instead to reference cells which I have set to update since I would rather not have to change the formula every three months. Current formula is as follows:

    =SUM(SUMIFS(RAW!$AN:$AN,RAW!$T:$T,$A11,RAW!$C:$C,{"2012 / 11","2012 / 12","2013 / 01"}))

    So instead of using the "YYYY / MM" I'd like to simply reference a set of cells containing that data. Possible?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    04-03-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    75

    Re: SUMIFS with "array OR" and cell reference

    Also, I do know I could simply combine 3 SUMIFS statements, but I'd rather the more elegant solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-10-2014, 08:10 PM
  2. reference date above last cell in range displaying "1" or "2"
    By leeroyrooney in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 05:41 PM
  3. Replies: 9
    Last Post: 11-06-2012, 08:59 AM
  4. can a "MINIF" formula be built, equivalent to "SUMIFS"?
    By jrtaylor in forum Excel General
    Replies: 4
    Last Post: 10-22-2011, 12:44 PM
  5. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

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