need help with choosing and using the right formula
I am trying to create a formula for the highlighted total paid cell. If someone paid this week then yes goes in the paid this week cell which will then add £2.00 to total paid. If no then nothing is added. When adding numbers to the weeks in advance column I want it to increase the total paid by increments of £2.00 for example 1 is £2.00, 2 is £4.00 etc. The opposite effect needs to happen for previous weeks owed column for example 1 is -£2.00, 2 is -£4.00 etc. Is there a formula that can make this happen? Please see photo for example. Paid this week is yes (£2.00) weeks in advance is 1 (£2.00) previous weeks owed is 0 (£0.00). So total of £4.00
Many Thanks
iPhone 16 Pro Max, iOS 18