How to Add Particular Column values in excel dynamically?

[Vaishnav_Tej]

Hi Community,

I want to know how to do summation of highlighted values.
Note : Row position of the values are dynamic. Also no. of rows are dynamic

Please help me with the logic.

Thanks in Advance

[Harshith_Adyanthaya]

Hi @Vaishnav_Tej ,

FindSum= (from r in inputDT.AsEnumerable where Double.TryParse(r.Item(“ColName”).ToString,Nothing)=True).Sum(Function(x) cdbl(x(“ColName”).ToString))

Hope this helps.