+ Reply to Thread
Results 1 to 3 of 3

SUM(IF) vs External source and partial lookup

  1. #1
    Registered User
    Join Date
    08-15-2017
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    2

    SUM(IF) vs External source and partial lookup

    Hi,

    I have entered a formula as shown below; however, using an external source, it will not work when closed.
    Tried to solve with SUM(IF) - but search criteria won't go throug4h.

    Any suggestions on how to solve?

    =SUMIFS('[ExternalSheet.xlsx]Input'!$P:$P;'[ExternalSheet.xlsx]Input'!$I:$I;"*es";'[ExternalSheet.xlsx]Input'!$M:$M;$B61;'[ExternalSheet.xlsx]Input'!$C:$C;SameWorkbook!$G$1)


    Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: SUM(IF) vs External source and partial lookup

    Does this work?

    SUMPRODUCT((RIGHT('[ExternalSheet.xlsx]Input'!$I:$I,2)="es")*('[ExternalSheet.xlsx]Input'!$M:$M=$B61)*('[ExternalSheet.xlsx]Input'!$C:$C=SameWorkbook!$G$1))


    You'll need to incorporate RIGHT(....,2)="es"
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    08-15-2017
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    2

    Re: SUM(IF) vs External source and partial lookup

    Thank you for your time, this works perfect!

+ 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. [SOLVED] Lookup partial values and if match return partial value from another cell
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2017, 07:53 AM
  2. Partial lookup from text string, return value from lookup list
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-13-2016, 12:14 PM
  3. Replies: 5
    Last Post: 03-26-2014, 08:30 AM
  4. [SOLVED] Hyperlinking to and Copying external PDFs where only prefix/partial file name is know
    By skalumba in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-04-2013, 03:10 PM
  5. Replies: 5
    Last Post: 07-29-2012, 04:42 PM
  6. Replies: 5
    Last Post: 02-24-2011, 11:26 AM
  7. external source is not available
    By SJDANIELS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2009, 01:43 PM

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