Hello. Looking for help. Searched forums and didn't find exactly what I am looking for. Here is what I am trying to accomplish:
- Column A contains list of three names in repetitive order: John, Bob, Mary. The range in column A is A6:A20
- Column B contains $ amount associated with each name. For example: A6 = John, B6 = $100; A7 = Bob, B7 = $200; etc
- Column C contains the status of whether bill was paid by John, Bob, etc. For example: A6 = John, B6 = $100, C6 = "paid"; A7 = Bob, B7 = $200, C7 = "pending"
- Then, there are three cells with running totals for John, Bob and Mary, A3, B3, C3. As columns A and B are getting populated, the running total for corresponding name is reflecting the total current sum paid. The only caveat is a "running total" cell should only add to the total sum if the status in column C shows "paid" and if it shows "pending", then the amount pending shouldn't be part of total sum.
Hope it all makes sense. An example is attached. I would appreciate your help.
Bookmarks