I am looking for a formula that I can take the "Payment" amount from A column, and add them to a single cell on, for example, C1. But the amount from each cell on A1 can only be added to C1 if the corresponding cell in column B says Yes. if it says No, then the amount in the corresponding A column is not added to C1.
Bookmarks