Sum of values in a column in excel that are all related to the same single value present in another column

Help Activities
, ,
5

@Adell90
prepare the target datastructure with a

  • build datatable activity
    • model the 3 cols: ClientName, InvoiceCount, Sum (feel free on col names) -
      output/Variable: dtResult

Use an assign acitvity
Left side: dtResult
Right side

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("ClientName").toString.Trim into grp=Group
Let s = grp.Sum(Function (x) CInt(d("InvoiceValue").toString.Trim))
Let ra = new Object(){k, grp.Count, s}
Select r=dtResult.Rows.Add(ra)).CopyToDataTable

with these two steps you will create the report as specified above. Feel free to read more about Grouping Data and LINQ here: