Hi @Sayantan,
Read the xl into a Datatable. Please the refer the below link procedure.
" ListA=(From p In dta.Select()
Group p By ID=p.Item(“ID”).ToString Into GroupA=Group
Select Convert.ToString(GroupA.Sum(Function(x) Convert.ToDouble(x.Item(“Amount”).ToString)))).ToList() "
Above code will solve your problem.
Regards
Balamurugan