How to calculate sum?

How to perfrom sum action at the end of a column where the last column is not fixed?
Here, sum is to be performed at the highlighted area and this area is not fixed it can be anything. per

Could you please help me with this process?

Hi @mk15 is it an .xlsx or a .csv file you are working with?

Hey ashapkina
It’s .xlsx

Then you can read the data from Excel to a table variable, calculate the number of rows in it, and define the coordinate of the cell as “number of rows + 1”.




Hope it helps!:slightly_smiling_face:

How do i calculate the sum for Item A in MAY and JUN using windows control?
I am still new to the software…