All Forums  Origin Forum  Origin Forum  Conditional data summation

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 falagar[/i] [br]Hi, I have a set of data that includes columns with data and columns with "markers". The data is the summation of measurement values and the marker value A shows at which point in the column the summation starts again from 0. Then there is in the marker column a marker value B which shows that a set of summations is finished. I need to take all the summation values (marked with A) of one set (end marker B) and sum them up. As there a a lot sets of summations I do not want to do it "by hand". Is there a script based solution? (I know that if the summations occured in defined rows I could simply say: sum up column G from 1 to 5 and 6 to 10, but it isnt that easy.) (G)(H) 1 x 3 x 4 A 1 x 2 A 1 x 2 x 4 B 1 x 3 x ....... [u]Need:[/u] sum (if H includes A or B take value from G, but only until B, then start again from 0) Thanks ! [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.