How to add the values of a table column

[S P P]

What would the formula look like if you eliminate columns E and F

As in the example of this spreadsheet

 

[AlanSidman]

Using Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Date] <> null)),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Date", type date}}),
    #"Inserted Year" = Table.AddColumn(#"Changed Type", "Year.1", each Date.Year([Date]), Int64.Type),
    #"Inserted Month" = Table.AddColumn(#"Inserted Year", "Month.1", each Date.Month([Date]), Int64.Type),
    #"Grouped Rows" = Table.Group(#"Inserted Month", {"Year.1", "Month.1"}, {{"Totals", each List.Sum([Total]), type number}})
in
    #"Grouped Rows"

 

[S P P]

Thanks
I got it like this
=SUMPRODUCT((Month(Table1[Date])=B3)*(Year(Table1[Date])=C3)*(Table1[Total]))

 

[S P P]

I'm interested in knowing what it would be like with Formula Somases

 

[Debaser]

You could use:
=SUMIFS(Tabela1[Total],Tabela1[Date],">="&DATE(C3,B3,1),Tabela1[Date],"<"&DATE(C3,B3+1,1))

 

[S P P]

Good morning!

Debaser

Something went wrong in the formula you wrote or I did something wrong

 

[Debaser]

Remove the @ before the last DATE function.

 

[S P P]

Thanks

It worked perfectly

Helped to eliminate two columns