how to do sum of amount of same date and set staus reconciled otherwise reconciled
Can you elaborate you query little bit in detail?
If you want to sum the column in excel you can try with the below linq
(From d in dtData.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)
Regards
Gokul