All Forums  Origin Forum  Origin Forum  Average worksheet rows

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by SteveS2[/i] [br]Origin 7.5 SR6 Window XP SP2 I have test data that I looking to analysis. The data is grid that has 12 thermocouples. I want to find the max, min and average values for each row. I am using the Set Column Function to create the functions Max(Col(B),Col(C),Col(D),Col(E),Col(F),Col(G),Col(H),Col(I),Col(J),Col(K),Col(L),Col(M)) This function works Min(Col(B),Col(C),Col(D),Col(E),Col(F),Col(G),Col(H),Col(I),Col(J),Col(K),Col(L),Col(M)) This function works Avg(Col(B),Col(C),Col(D),Col(E),Col(F),Col(G),Col(H),Col(I),Col(J),Col(K),Col(L),Col(M)) This function does not work Is there a function that will average column values for each row? I can alway add the columns and divide by 12, I am just looking for a average function. [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.