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

Good morning Glenn,

Thanks a lot! It works and you made my job a bit easier at the moment
Have a nice day!


Kind regards,

Thomas

Good afternoon Glenn,

You helped me with this solution last year. But I like to ask you how I need to modify this sum when I like to refer to another tab. Let's say ''Tab1'' for example.
I ask this question because I like to move the sums I made to another tab, but all the information for the sum will stay in the first tab.
Can you help me with this?

Hope to hear from you!


Kind regards,

Thomas

Good morning Glenn,

Thank you for your answer.
It works indeed like you told me. But I can't use the formula in the attached file. Tab 3 (Overview per quarter 2023) cel B3 & B4 for example.
Do you know what I'm doing wrong?


Thank you in advance!

Thomas

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Tabel1"]}[Content],
    #"Removed Columns" = Table.RemoveColumns(Source,{"Kolom1"}),
    #"Extracted Month Name" = Table.TransformColumns(#"Removed Columns", {{"Date:", each Date.MonthName(_), type text}}),
    #"Grouped Rows" = Table.Group(#"Extracted Month Name", {"Project/Cost:", "Date:"}, {{"Debit (€)", each List.Sum([#"Debit (€)"]), type nullable number}, {"Credit(€)", each List.Sum([#"Credit (€)"]), type nullable number}, {"Debit(PLN)", each List.Sum([#"Debit (PLN)"]), type nullable number}, {"Credit(PLN)", each List.Sum([#"Credit (PLN)"]), type nullable number}})
in
    #"Grouped Rows"

I did check this cell, and the ones right next to it. But they are all clear. How can I check source data?

You are right, I deleted some rows in the other document so it was another cell with spaces. Thank you very much!

Yes all good, thanks!