You can use For Each Activity but as follows:
For each row
→ Assign activity: sum = CINT(row(“Value A”)+CINT(row(“Value B”)+CINT(row(“Value C”)
→ If: sum < 1000 Then → here you can set your activities, what you want to do
I don’t only need the sums by row, I need every “threesome” of Value A + Value B + Value C, where the differents values could be from different suppliers.
I solved by this method:
1)Creating three List for A, B and C extracting the values from the dataTable.
2)Setting a Do While with nested IF’s for checking index of the three list, that sum in first place : A(0) + B(0) + C(0)
3) Then it sums the next C element : A(0) + B(0) + C(1)
4) Once it has summed all the elements of C, adds 1 to the index of B and set to O the C index: A(0) + B(1) + C(0), and starts again to advance over C Index.
5) etc… to finally sum A(n) + B(n) + C(n)
I hope I explained well. I would probably could find a more elegant way but it do the work I need