What I want to achieve is, to create a universal formula for Bob, George, Charles, to calculate their balance based on "Affects balance" field.
So in the example below results would be following:
C3: 400, D3: 150, E3: 240, F3: 10 //(Because in/out field affects only Bob's balance)
C4: 280, D4: 90, E3: 240, F3: -50 //(Because in/out field affectS Bob's and Charles's balance equally)
Please take a look at this example sheets:
https://docs.google.com/spreadsheets/d/1NggjOiebkfUguugtw6lrzBy11F5fVJdree_WG0H3jVA/edit#gid=0
I can't figure out how would be the formula. Any suggestions?