I now have a list of data, at 0 to separate into different length of a few pieces, I now have to be an average for each fragment, already with the formula of rows and columns, is there any way to these fragments on the excel for average?

CodePudding user response:

Ok, use=average (offset (... )) formula, offset () is used to create a scope, a first cell, have rows and columns, range is ok, however, didn't understand you the meaning of this figure, 5.95 what how to calculate,