How to Sum Negative and postive values in a single column in Excel

[kumar.varun2 (Varun Kumar)]

@surya_teja.k

try this

dt.AsEnumerable.Sum(Function (x) If(x(1).ToString.Replace(" ","").IsNumeric, CDbl(x(1).ToString.Replace(" ", "")), 0 ))