Sum of Multiple rows

[Shriswaroop_Joshi]

Hi ,
I am having huge data in excel. I have a datatable and I want to do a sum of multiple columns.

H4: sum(C4:G4). Can some one please help me? Attached sheet for the same
Test.xlsx (519.1 KB)

[Srini84 (Srinivas)]

@Shriswaroop_Joshi

Check below for your reference

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

@AlexRPA If you just need to sum a column, I would suggest using the syntax like this: tblaccount.AsEnumerable.Sum(Function(x) Convert.ToDouble(x("AVAIL_BALANCE").ToString.Trim) ).ToString You can filter to only certain columns also using .Where, like this: tblaccount.AsEnumerable.Where(Function(x) x("column").ToString.Trim.Equals("123456")).Sum(Function(x) Convert.ToDouble(x("AVAIL_BALANCE").ToString.Trim) ).ToString I hope this helps. Regards.

Hope this may help you

Thanks

[Shriswaroop_Joshi]

I am looking for sum of multiple row and not column