Complex formula in Google Sheets

[cmccambridge]

Hi, Can anyone help with this complex formula??

Two Goals:

1) SUMIF - Column C = Specific Dept, Add the total in column H (This part I know, but then I need to add date considerations for part 2)


2) Compute quarterly salary expense by Hire date: ie: if hired in column D - Calculate the total salary expense in H for Q2 2023 per department.


Thanks for the help!!