Calculating value when a condition is satisfied

Hi,

I would like to calculate the value when the department is null and the year is 2020 to department CS year 2020. Please let me know a solution for this.

Attaching a screenshot of the worksheet for reference.

Thanks.