Calculate Freelancer Expenses

[daithioc95]

https://docs.google.com/spreadsheets/d/1Ox9BqXPFIFdxp6r01sdzJwmUYlpg_MiNbFkpq2mw2bU/edit#gid=0
Calculate the amount for each client per client project.
Occasionally N/A error appears on timesheet so ensure the formula ignores N/A error
Cells D39:D280
Formula needs to 1/ find the date for the corresponding month (Timesheet column A), 2/ find the freelancers name (Timesheet column B) and 3/ sum the amounts while ignoring N/A (Timesheet column C)

Links to Client Timesheets

Client 1 https://docs.google.com/spreadsheets/d/1wldjlRUzSKzUYXVI7gIIJgbfMDOG8gWHq07zephzKlI/edit#gid=645943345
Client 2 https://docs.google.com/spreadsheets/d/1yMvP4unMBsmswAFzPy6LAXZxhTmVypu4_xXuk8iNYgY/edit#gid=141091263
Client 3 https://docs.google.com/spreadsheets/d/1rTDZwdrzDkZRsrvH1sms5lTBb0NlsbSCs0Y3zkyeueE/edit
Client 4 https://docs.google.com/spreadsheets/d/1clnLaS2RpLvf5mCOQwo9tOHki0DLqwN5J8HV7fJqmcI/edit#gid=0
Client 5
https://docs.google.com/spreadsheets/d/1Zfvat7TP0rPE7EOS4lElr-t7eVxAqlmSG37dh2VLXok/edit#gid=0
Client 6 https://docs.google.com/spreadsheets/d/1fHShi7L1ZLxKPYojl7gjMxFjiL6L4txAeZ7akf9vzd0/edit#gid=0
Client 7
https://docs.google.com/spreadsheets/d/1QdV3v-BNrNbV0gCaGgzEhvWyhQPIGHf1-mrQA0hoThM/edit#gid=0
Client 8
https://docs.google.com/spreadsheets/d/1L_APMJuDZzc4zwg6bC26MnkKfzhgAGfjuvBI1stQe8/edit
Client 9 https://docs.google.com/spreadsheets/d/1awYc0ilvJcKDm6Su1eFaUjbcelvy3t_Cj5MApNYBeJc/edit#gid=0
Client 10 https://docs.google.com/spreadsheets/d/1Sb7O1bGI_agqgrd4Zzw6cJEBgz0GBOxnpv321bAmE94/edit#gid=0
Client 11
https://docs.google.com/spreadsheets/d/1pDy1tXeso-HEYFLMhNb7RC6vPF0psrS0QeNXy1eBcOw/edit#gid=0
Client 12 https://docs.google.com/spreadsheets/d/1nHZG3uwClqE_5GLXDb1thISNuSKQMQSuCmxtck7mSU0/edit#gid=0
Client 13
https://docs.google.com/spreadsheets/d/1255BhM0yTF83uJkImiqRsXG5m46WQqL2q5-6q7KftEk/edit
Client 14
https://docs.google.com/spreadsheets/d/1QFplhfGLfjXvFJY5TV04P-MklrzxGbNlrQdVcea1WQ4/edit#gid=0
Client 15
https://docs.google.com/spreadsheets/d/1uPCLK8UYDIArDk4125tWO6XLlwGuKDwBiQrlfe-gofc/edit#gid=0