Count total of staff hours excluding hours for any leavers

Hi

I have a list containing each member of staff and their contracted hours. There is also a column for a leave date and if there is a leave date for the member off staff in that row then I need it to not include the contracted hours for them in the total.

Is there a formula I can use to achieve this?

The contracted hours are in G9 to G158, and the leave dates are in cells C9 to C158.

Thanks!

I updated your title to reflect your second post, and removed the second post so your thread continues to be shown in the Unanswered Threads list. --6SJ