+ Reply to Thread
Results 1 to 2 of 2

How to combine 2 array formulas

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    How to combine 2 array formulas

    I have 2 array formulas on a sheet that i would like to combine.
    Array 1 works independently by itself

    =IF(M7="","",SUMPRODUCT(($C$19:$K$27=M7)*IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7))

    Array #2 is like the first just pulling from another range of data, but when it runs I would like it use the answer from the first one if the data in "M7 & M63" are the same.

    =IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+(N63))

    Maybe something like this

    =IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+SUMPRODUCT(($C$19:$K$27=M7)*IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7))

    it seams to work but can it be simplified

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: How to combine 2 array formulas

    Complete shot in the dark without any data to test against...
    =IF(M7="","",SUMPRODUCT(($C$19:$K$27=M7)* IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7))
    =IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+(N63))

    =IF(M7="","",if(m7=m63,SUMPRODUCT(($C$19:$K$27=M7)* IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7)),IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+(N63))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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: 3
    Last Post: 01-01-2016, 03:44 PM
  2. Replies: 5
    Last Post: 06-12-2015, 07:02 PM
  3. Replies: 2
    Last Post: 06-19-2013, 12:59 PM
  4. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  5. Ctrl+Shift+Enter (CSE) array formulas in VBA using differing formulas
    By officeguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 04:31 PM
  6. Replies: 6
    Last Post: 12-30-2008, 06:52 AM
  7. Replies: 1
    Last Post: 08-25-2005, 03:43 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