How to sum all values in a column of an excel/Datatable?

Help
, ,
45

Yeah for LINQ, I think you got it right.
To use Where, it’s just like the Sum:
InputBalanceDT.AsEnumerable.Where(Function(r) r("Type").ToString.StartsWith("200.") ).ToArray.Sum(Function(x) If(IsNumeric(x(“Value”).ToString.Trim),CDbl(x(“Value”).ToString.Trim),0))

4 Likes