You are reading a single comment by @christianSpaceman and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@christianSpaceman
@WjPrince I put your exact table in a sheet starting at A1.
Then this formula goes into column E (this one for row 2 -i.e. the dec 16 row):
=IF(COUNTIF($E$1:E1,"="&"repaid!")>0,"",IF(SUM($C$2:D2)+IF(E1="",0,E1)>2000,"repaid!",""))
Copy it down column E.
PM me if you want me to email the spreadsheet