I run a football group, and I'm trying to simplify recording of the weekly subs, using a spreadsheet.
Starting with a Balance (F2), I want to add any weekly payments (E3, and below) and subtract £2 subs if they play (D3 = "Y", and below).
I thought the (fairly simple) formula shown would calculate a running balance, but something's wrong! Any ideas?

Starting with a Balance (F2), I want to add any weekly payments (E3, and below) and subtract £2 subs if they play (D3 = "Y", and below).
I thought the (fairly simple) formula shown would calculate a running balance, but something's wrong! Any ideas?
