Auto-sum with multiple conditions

Good afternoon all,

My question might be an easy one for a lot of you, but I'm struggling a lot to get it right.

I try to make a formula which calculates the total amount with two conditions combined. The first condition is the subject in column A and the second condition is the month in column G. (see attached example file)

For example I like to know how many bank costs we had in January by calculating all bank costs from January in column B (€) - the bank costs in column C + the bank costs in column D (PLN) (but calculated to € with an exchange rate, for example 4.6) - the bank costs in column E (PLN) (and also calculated to €).

I tried different formulas, but non of them worked for me. I hope somebody has a good solution!

Thank you in advance and have a nice day!


Kind regards,

Thomas