Hi, can someone help me. I need to calculate the sum of 3 column. From top table, to become the lower table [image] Really appreciate if someone can give me the solution

@Hakim_Asyraf find starter help here: GroupBy_Sum_2Col.xaml (8.6 KB) in your case it could look like this (From d In dtData.AsEnumerable Group d By k=d("PO Number").toString.trim Into grp=Group Let cs1 = grp.Sum(Function (x) Convert.ToDouble(x("PO Line Qty").toString.Trim)) Let cs2 = grp.Sum(Fun…

How to group by and sum 2 column in Excel

Help

Hakim_Asyraf (Hakim Asyraf) November 17, 2020, 10:27am 4

Actually I want to sum with the value from column B

Topic		Replies	Views
How to group by two column and sum up the rest of the column Learning Hub excel , activities	3	1849	March 26, 2020
How to get sum of a column after grouping on two columns Help	3	2843	November 5, 2018
How can I get data by grouping one row and sum related to grouping in 2nd column Academy Feedback datatable , excel , activities , question	2	790	April 5, 2020
Find the group having duplicate values and sum the column Learning Hub datatable , excel , uiautomation , activities	3	1410	March 18, 2020
How to Sum column values in Excel Studio studio , question , workflow_diff	5	1620	May 6, 2021

How to group by and sum 2 column in Excel

Related topics