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.
