Sumifs

Hi I have uploaded the sheet as an example

What I basically need is a formula that sums in sheet 2 cell d4, from sheet 1, if, in col A it reads "Total Revenue" and in col F it reads "Not Assigned" then populate the respective months.

Sheet 1 in reality has hundreds of lines so need to be able to copy down.

Thanks