Results 1 to 3 of 3

Thread: How To Use Or Pass A Dynamic Reference In An Array Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    0

    How To Use Or Pass A Dynamic Reference In An Array Formula

    Hi,

    I am using a formule as: =SUM(SUMIFS($E:$E;$A:$A;H$1;$C:$C;{"*appel*";"*ban aan*"}))

    However the values {"*appel*";"*banaan*"} change once in a while and i do not want to change the formula everytime (to add or remove a product.

    Is it possible to replace the {"*appel*";"*banaan*"} by a reference cell or reference cells? something like:
    =SUM(SUMIFS($E:$E;$A:$A;H$1;$C:$C;{X1}))

    i tried various things and looked on the forum but i am not able to find an answer on how to do this. I attached an example of the sheet to this thread, any help or ideas are welcome.

    Thanks,
    Wilco
    Attached Files Attached Files

Similar Threads

  1. Create A Dynamic Border Using Excel Native Formula
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-02-2013, 06:07 AM
  2. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  3. Combining Functions To Create Array Formula
    By Ryan_Bernal in forum Excel Help
    Replies: 3
    Last Post: 01-07-2013, 12:38 PM
  4. VBA To Pass A Variable In An Excel Formula
    By devcon in forum Excel Help
    Replies: 4
    Last Post: 12-17-2012, 09:12 PM
  5. Replies: 3
    Last Post: 04-08-2012, 09:44 AM

Posting Permissions

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