Results 1 to 3 of 3

Thread: Formula tweek index match formula needs to also be a sumif

  1. #1

    Formula tweek index match formula needs to also be a sumif



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    I have this formula which works well for one indiviual instance. But if there are multiple occruences for a specific indivual it will not some all their occurences of "PAID" only the first.


    {=IFERROR(INDEX('SHEET1!$F$2:$F$6000,MATCH(D6&A6&"PAID",'SHEET1!$A$2:$A$6000&'SHEET1!$B$2:$B$6000&'SHEET1!$G$2:$G$6000,0)),"")}

    Any Help would be greatly appreciated.

    MZING81

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    118
    Articles
    0
    MATCH doesn't do multiple occurances.

    How about this:

    Code:
    =SUMPRODUCT(Sheet1!$F$2:$F$6000,--(Sheet1!$A$2:$A$6000=D6),--(Sheet1!$B$2:$B$6000=A6),--(Sheet1!$G$2:$G$6000="PAID"))
    Cheers,

  3. #3
    Quote Originally Posted by cheshirecat View Post
    match doesn't do multiple occurances.

    How about this:

    Code:
    =sumproduct(sheet1!$f$2:$f$6000,--(sheet1!$a$2:$a$6000=d6),--(sheet1!$b$2:$b$6000=a6),--(sheet1!$g$2:$g$6000="paid"))
    cheers,
    thank you so much it worked perfectly!!!

Posting Permissions

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