Forum Discussion
IF/AND Formula?
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.
1 Reply
- Which screenshot is for which sheet. Better attach a sample file so that we can download and work.
