IF/AND Formula?

Frequent Visitor

I need a formula to look up and sum a value if 2 conditions are met. I have a tab with a details and a summary tab. The details tab includes a column for amount pledged, a column for funds received (Received vs. Pending) and a column for the member whom raised the funds. I need a formula to calculate the amount received for each member and another column to calculate the amount pending for each member.Capture1.PNGCapture2.PNG

1 Reply
Which screenshot is for which sheet. Better attach a sample file so that we can download and work.