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

1. 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

2. 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)

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

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