Bring Value with Sumifs in Pow.Query language to specified row, and column(location)

Next step? I have brought with sumifs and a lot sumif from other workbook, information to the exact row, column in excel workbook. Now I want to do the same with query language. I can bring two values if condition is met, but then it is unclear how I will bring the total sum to the one row in excel workbook. Can anyone show me the path? I guess I will need Data Model...

= Table.AddColumn(#"Changed Type", "Sumif", each if [Column2] =2 or [Column2]=1 then [Column3]+[Column4] else 0)


let
    Source = Folder.Files...
    #"C:\Users...
    #"Imported Excel" = Excel.Workbook(#"C:\...
    SegPL_Chart = #"Imported Excel"{[Name="SegPL_Chart"]}[Data],
    #"Removed Top Rows" = Table.Skip(SegPL_Chart,12),
    #"Removed Alternate Rows" = Table.AlternateRows(#"Removed Top Rows",1,1,90),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Alternate Rows"),
    #"Filtered Rows" = Table.SelectRows(#"Promoted Headers", each ([Col1]="1" or [Col1]="2")),
    #"Table Group = Table.Group(#"Filtered Rows", {}, List.TransformMany(Table.ColumnNames(#"Filtered Rows",(x)=>{each if x = "Names" then "Totals" else List.Sum(Table.Column(_,x))},(x,y)=>{x,y})),
    #"append" = Table.Combine({#"Filtered Rows",#"Table Group"})
in
    #"append"

It gives an error "in" Token comma needed..? What else I need to do bring total rows?

Solution

You can use several steps to create several helper columns with intermediate results of conditional sums. Then you can create a new column, sum up all the intermediate results and the delete the helper columns with the intermediate results.

Keep in mind that unlike Excel, the calculations in Power Query always return constants and you can then delete calculated columns you no longer need. So,

Create helper column 1 with complicated IF and Sum scenario
Create helper column 2 with complicated IF and Sum scenario
Create total column to add column 1 + column 2
Delete helper columns and keep only the total column