Find the total value for the ids

[beepetark]

Hi excel experts please i need this solution for this query with i attaching image with this message
query is how to find the total rates as per ids without disturbing data

 

[sandy666]

with Power Query

ids	rates		ids	Sum
A	13		A	85
	17		B	41
	14		C	51
	20		D	70
B	17
	11
	13
C	11
	15
	13
	12
D	20
	16
	17
	17
A	10
	11

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Fill = Table.FillDown(Source,{"ids"}),
    Group = Table.Group(Fill, {"ids"}, {{"Sum", each List.Sum([rates]), type number}})
in
    Group

 

[beepetark]

only through functions in excel

not using power tools

Thanks for your reply

 

[sandy666]

sure
have a nice day