Determine the number of terms by year in Google Sheets

I have two tabs in my Google Sheets file. One of these tabs contains our guests' data.

datas

The other is a summary of payment methods by years.

Summarise

Could you explain me, how can I fill in the summary cells with the datas from the other tab?

Thank you!

Solution

Use this formula in cell B3 and expand over the other cells:

=count(filter(Adatok!$C:$C;year(Adatok!$D:$D)=B$2;Adatok!$E:$E=$A3))