Adding Sum of Specific Data In Excel

[Palaniyappan (Palaniyappan P)]

Hi

Have a View on this thread with a expression to group and sum a column

Linq query for groupby and sum

I have a datatable as below. I want to group by using Col3 and take sum of Col2. Input Datatable: Col1 – Col2 – Col3 – Col4 A – 11 – AA – XYZ B – 12 – RT – XYZ C – 13 – HL – XYZ D – 27 – AA – XYZ E – 17 – AA – XYZ F – 15 – RT – XYZ G – 24 – HL – XYZ OutPut required: Col1 – Col2 AA – 55 RT – 27 HL – 37 Please help me with the LINQ query. @ppr @arivu96 @ClaytonM

Cheers @Rishik_Chowdary