+ Reply to Thread
Results 1 to 2 of 2

need help in sum up multi criterias (index & match)

  1. #1
    Registered User
    Join Date
    10-14-2006
    Posts
    3

    need help in sum up multi criterias (index & match)

    Hi all,

    Please find the screenshot in attached file.

    I have 4 customer in the list. Each customer can have more than 1 security number.

    as per example in the file, for customer 2, security number are same. so i will look at the security type, if the security type is different, then i will sum up both security amount. if the security type is same, then i will take the highest security amount. if the security amount is same, i will oni take 1 amount.

    how should i write the formula? i have 3000+ lines to go. can i use index & match function?

    thanks
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    09-28-2006
    Posts
    11
    Hi,

    You can try this. In row 2,

    * Put this in column G
    =IF(A2=A1,G1+IF(AND(IF(A2=A1,TRUE,FALSE),C2<>C1),D2,0)+IF(A2=A1,0,D2),IF(AND(IF(A2=A1,TRUE,FALSE),C2<>C1),D2,0)+IF(A2=A1,0,D2))
    * Put this in column H
    =IF(A2=A3,,G2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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