Origin Ver. and Service Release (Select Help-->About Origin): Operating System: 9.8.5.201 , Win10
Hello! I have a "simple" index problem and hope that someone can help.
I have a column A with data points and I want to calculate the mean value of certain points (not all) between the rows x and y.
The index for x and y should be easy to change - thus I want to put x and y in column B and C as the first value.
To calculate the mean value of the values in column A between row x and row y I used the following formula:
mean(A[B1:C1])
But in this way I only the mean value of the two values at position x and y. The values in between were not taken.
So basically I need the right syntax to get out all values between index x and y without putting x and y directly into the formula. This is important as the same indices should be used for multiple different calculations.
One more question came up... When I chance of the indices or even values in the respective column (A), the calculated values are not updated. Everything is set to "recalculate automatically" but nothing happens
The only way it is recalculating with new values is when I type in the formula again. Is there a solution for this? So that all calculations are recalculated every time when I change the indices?