Sum values from columns to a seperate sheet

[nischal4487]

Hi

I have a Column A with values - John,Mike, Sara , Tim etc
Column B contains timesheet hours which are repetitive values against each of the the names ,like

John- 10
Mike-20
John-50
Sara-30
Sara-25
Tim-80
John-50

I want to get the sum of the values for each of these names in a separate sheet without using a pivot chart.

Please help

 

[gazisere]

How do you mean the sum of these values? (I.E Are you trying to add multiple workbooks together, or have multiple columns?)

 

[nischal4487]

Sorry If i was not able to make my question.

My end result should be Sum of the hours for each of the employee name in a different sheet like

John- 110
Sara - 55

 

[sandy666]

without Pivot but with PowerQuery and defined name for source range

John	10​		Column1	Sum
Mike	20​		John	110​
John	50​		Mike	20​
Sara	30​		Sara	55​
Sara	25​		Tim	80​
Tim	80​
John	50​

[SIZE=1]// Query1
let
    Source = Excel.CurrentWorkbook(){[Name="tblname"]}[Content],
    Group = Table.Group(Source, {"Column1"}, {{"Sum", each List.Sum([Column2]), type number}})
in
    Group[/SIZE]