Hi Lea,

Not sure why you want to go for the pivot table?

Here a possible solution with summing the countifs. It doesn't look nice, but works good I think.

Hi Lea

I noticed that there are difference in the Month between  Table1 and Table2. Example: Chana have months June-August in Table1 but April-June in Table2. That is why your Pivottable is incorrect.

If you enter the Month similarly in both Table1 and Table2, the PivotTable will give you the answer just like what Frans Visser got using Formulas.

Hope this helps.

Sunny

Thank you very much for the detailed answer! 
I added his payment every month and I already have a summary for each student
And I would like to receive in a separate table the names of the months and the total amount that entered that month
Thank you

Hi Lea

Can you attach your data and the expected results (with some explanation)?

It would be easier to understand what you actually wanted.