Formula in one cell that picks up another based on dates provided in the same sheet

Hiya,

I am looking for a formula that will pick up whatever is in one cell based in if the date above is within that certain month and then duplicate the formula for each month so only figures for that month will appear on the first worksheet.

I need a formula for Monthly Salary & Wages TAB cell C6 (Which is a cell for the total July Salaries and wages) to look at the Payrun Pay Dates in the Summary of LPS Salary & Wages TAB and add all the amounts up in row 6 if they are for the July month. I then will also need this to flow across to each month so i can get a total figure for each month.

I hope someone can help me!

Thanks

LPS.xlsx

Oh okay, Thankyou

I have provided a version will some information included.

Thanks!

LPS - TEST.xlsx