I have applied IF to 5 cells that work but one wont

I am trying to create on spreadsheet Cash flow january - an automated add on for the drop down list. It is a cash flow distribution, so it will automatically add up person by person and then month by month so the overview page will be automatically updated.
Hope this explains it a bit better. The working out is on sheet 1.
Thank you