Sum V Lookup help

[PierremontQuaker03]

Hi, I appreciate the help in advance, in columns I to J I am wanting the sum of he values that match 3050030 - vlookup only picks up the first value that matches - but I want it to sum the value of the matches. Many thanks

 

[AlanSidman]

With Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Column1] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column2","Column3","Column4", "Column5", "Column6","Total"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {"Column1"}, "Attribute", "Value"),
    #"Grouped Rows" = Table.Group(#"Unpivoted Other Columns", {"Column1", "Attribute"}, {{"Totals", each List.Sum([Value]), type number}}),
    #"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[Attribute]), "Attribute", "Totals")
in
    #"Pivoted Column"

0

Oct-25

Nov-25

Dec-25

Jan-26

Feb-26

Mar-26

Apr-26

May-26

Jun-26

Jul-26

Aug-26

Sep-26

3050030

245683.2447​

259093.9632​

208097.8689​

225167.1036​

218400.2327​

234322.2068​

212825.6036​

234818.416​

242418.9409​

240665.9612​

222086.0793​

244470.0491​

3050040

8176548.213​

8622868.38​

6925674.806​

7493753.516​

7268546.274​

7798443.17​

7083017.856​

7814957.436​

8067909.397​

8009568.735​

7391214.395​

8136172.03​

 

[Debaser]

=SUMIF($B$7:$B$14,$D$25,I$7:I$14)
in I25 and copy across.

 

[PierremontQuaker03]

=SUMIF($B$7:$B$14,$D$25,I$7:I$14)
in I25 and copy across.

thank you Sir!