Need help with SumIfs & Data validation

Hello.

Perhaps this is level newb difficulty for some of the gurus here.

I am trying to figure out how to use SumIfs to display transactions made between 2 seperate time periods using Data validation from a list of entries in a seperate worksheet.

Sheet 1) Cells H33 to H44 and Cells K33 to K36 are intended to display the total amounts of the assigned categories found in Cells G33 to G44 and J33 to J46 respectively.
Cell C32 will use data validation to assign which person to use as a criteria for the next argument.

Sheet 2) Includes a list of tables used for data validation used in sheet 1 (persons, dates, month, yr)

Sheet 3) Displays all transactions and their amounts from which sheet 1 will summarize based on conditions found on sheet 1 cells C35,D35,E35 & C38,D38,E38.

In a nutshell, I would like to enter two specific time periods, and have excel provide a total amount spent during that window of time.

What is the best way to achieve this so that more entries can made?

pls view spreadsheet


Any help on this would be greatly appreciated.

Thanks,

Mr Nat

Excel help forum question (VLOOKUP & DATA VALIDATION).xlsxtake a look at what i have done