Duel Code Check and Pay

[houstonking]

Hello Friends - Really need help in formula. i have a sheet with many different codes like below example. And they have their own status. So i want to create a formula - that if there is same code and both of them have pay status then give the first line item 50 then the second one 25. Then the other formula i want is if there is same code then one has pay and the other has no pay status so it should get 0 and the first one should get 50. How can i do this please help!!!

Code Status Amount
45 Pay 50
45 Pay 25
50 Pay 50
50 NoPay 0
60 Pay 50
60 NoPay 0
61 Pay 50
61 Pay 25

[menem]

Due to my english, I need to re-confirm your requitement again.

Your code come as couple and connected, no skipped.
1st occurance of each code amount will be 50 if status is Pay
2nd occurance of each code amount will be 25 if status is Pay , or else 0.

C2

Please Login or Register  to view this content.

Regards.

[houstonking]

Due to my english, I need to re-confirm your requitement again.

Your code come as couple and connected, no skipped.
1st occurance of each code amount will be 50 if status is Pay
2nd occurance of each code amount will be 25 if status is Pay , or else 0.

C2

Please Login or Register  to view this content.

Regards.

Thanks for your help.