How to add values of 4 successive elements of a column?

Help
1

I have a CSV file where there are two columns inside it and I need to add first 4 rows of a column and then proceed to next 4 rows and add them and so on. How can I implement this task?

2

and what activities should I use?

3

@vivek_Chowdary

listOfString = dt .Rows.cast(of datarow). select (function(dr) dr(“column name”).tostring).tolist

This piece of code will extract the column as list

sum = list.sum

4

Thank you for your help. But, its not working.

5

@vivek_Chowdary

Here i have attached code sample containing the logic i am proposing.
Look into it and ask if there is any query.

Sample.zip (8.5 KB)

6

@ Raghu9060

Thank you for explaining it more briefly. The one which you have given adds all the numbers and displays the result. But, I want to add the first 4 values of the excel file and store it in another field and next 4 of them together and so on.

7

@vivek_Chowdary

Below attached is a mock solution for a query, is not as impressive. But it will solve your query for now.

Be posted I will try finding more optimized solution.Sample.zip (8.9 KB)

8

Thanks!

9

If the solution is working, mark as solution.