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
Bookmarks