I hope you may be able to help. knowledge of Excel is okay, however I am struggling with this one and any help would be appreciated!

I need to calculate the total of payments paid from a certain person based on a date range for over 300 people. For example in the following rows/columns;

Mr Smith - 1/4/18 - £123

Mr Hyde - 20/5/18 - £99

Mr Smith - 19/9/18 - £102

Mr Red - 5/12/18 - £32

Mr Hyde - 3/7/19 - £232

Mr Smith - 1/10/19 - £232

And so on....

Date range from X

Date range to Y

I know how to find and calculate the amounts for say Mr Smith etc with the SUMIFS formula, however I am unsure how to capture this information also based between 2 dates. For instance if I only want to find out how much Mr Smith has paid between X (1/4/18) and Y (1/8/19) how would this look in a formula and would I have to use an array?

Please bear in mind my data is not in columns next to each other like the example above and it spans over 300 rows.

Many thanks in advance!