Hi,

I'm having difficulty with a spreadsheet I want to create

I have a list of raw data which details payments to individuals and the associated date,

I want to calculate the sum of payments paid to each person for each month,

I think this might have something to do with arrays but I've not managed to get my head around this particular function yet,

I've attached a simple version of what I'm trying to achieve below

Excel Forums Example.xlsx

Any advise would be greatly appreciated,

Thanks in advance

Tom