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

Total of excel column

Eliminate Duplicates in Excel

Topic		Replies	Views
Linq query for groupby and sum Studio	15	18526	April 27, 2020
Linq Query on Group By and Sum Activities datatable , excel , activities , question , linq	4	5021	May 13, 2021
Help with LINQ Query to Group and Sum Data in DataTable Studio datatable , excel , studio , question , activities_panel , linq	7	113	August 5, 2024
Using linq performing group by and sum of dynamic columns Activities datatable , excel , activities , question	5	3555	November 15, 2021
Linq expression to group by and sum but keep other information Studio datatable , activities , studio , question , linq	5	1116	January 17, 2023

Most Active Users - Yesterday
ashokkarale
Yoichi
AkshaySandhu
Anil_G
sudster
heidi.michelsson1
Z15
Rahul_Rajendran
rpamailer
SorenB
More details...

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

Related topics