How do I group by one column in the datatable and take the sum of another column based on this grouping. I have attached a sample file for better understanding. group and sum.xlsx (9.7 KB)

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDa…

How do I group by one column in the datatable and take the sum?

Help

balupad14 (Balamurugan) March 12, 2018, 1:51pm 9

Hi,
Can you check this. It helps you.

file : group by one column in the datatable and take the sum.zip (3.1 KB)

Regards
Balamurugan.S

1 Like

Eliminate Duplicates in Excel

Total of excel column

Topic		Replies	Views
Linq query for groupby and sum Studio	15	17267	April 27, 2020
Linq Query on Group By and Sum Activities datatable , excel , activities , question , linq	4	4326	May 13, 2021
Using linq performing group by and sum of dynamic columns Activities datatable , excel , activities , question	5	3105	November 15, 2021
Linq expression to group by and sum but keep other information Studio datatable , activities , studio , question , linq	5	917	January 17, 2023
DataTable Group By Sum and Count using Linq Help	2	5630	January 29, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

How do I group by one column in the datatable and take the sum?

Related Topics