I have a set of worksheets with x and y column. I would like to add all the y column of different worksheets up. I know how to add them with same row. But could any one tell me how to add them with same x value? and make it to a new worksheets.
If you now execute the following line of command in your script window (menu command: Window->Script Window, type this line and then hit the Enter key) data3_b = data1_b(data3_a)+data2_b(data3_a)
the result will be:
Worksheet Data3: A(X) B(Y) 1 20 2 40 3 60 4 75
For value of x that are common to all worksheets, Origin just sums up the appropriate rows. For values of x that are not present in any worksheet, Origin gets the value for that worksheet by linear interpolation.
data analysis
Posted - 09/13/2002 : 11:07:13 AM
