Results 1 to 7 of 7

SUMIFS with Array Constant Fails

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2010
    Location
    Cadiz, KY
    MS-Off Ver
    2016
    Posts
    6

    SUMIFS with Array Constant Fails

    Hello folks, many hours trying to figure what I am missing. Notice in the formula below that one of the SUMIFS criteria is an array constant {"MCH","IGT","STT"}

    =SUM(SUMIFS(tData[Amount],tData[Plant],{"MCH","IGT","STT"},tData[Category],"Budget",tData[Date],X$7))
    That works fine. However, assume the array constant is elsewhere in a cell named 'fPlants'. I cannot figure out why the formula below will not work - it sums to zero which is incorrect

    =SUM(SUMIFS(tData[Amount],tData[Plant],fPlants,tData[Category],"Budget",tData[Date],X$7))
    If I step through the formula using Evaluate Formula, notice below that there are extra quotes added to the array constant

    Formula.jpg

    What am I doing wrong? Any advise would be appreciated
    Last edited by zCJH4254; 07-20-2014 at 02:39 AM. Reason: Incorrect title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-28-2013, 06:18 AM
  2. Dynamic array constants
    By michalrosa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2010, 04:01 AM
  3. Converting weeknumber formula to VBA (array constants)
    By opopanax666 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2008, 06:23 PM
  4. Formula Array Constants, Problem
    By pegbol in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2005, 02:45 PM
  5. Declaring array constants at module level
    By Microsoft Forum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2005, 03:06 PM

Tags for this Thread

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