Forum Discussion
Help for Excel
Mabey someone can help me. I' ve been searching for a formula on Excel, that counts the average of 24 lines in a tabel with some tausends of data points. Selecting manualy 24 Lines every time costs alot of time. Mabey it is possible to automaticly generate this average data with some fomula or something?
It's definitely possible, although your description raises as more questions than a simple answer can respond to.
IF what you're trying to do is get the average of 24 rows in sequence, just a different set of 24 each time, a formula like the following will do it. Let's assume the numbers to be averaged are in column C, going all the way from C2 to C2000. If you put this formula in cell D25 and copy it down to D2000, it will show you the average of the 24 cells that include the cell in column C adjacent to the one in D containing the formula, averaged in with the 23 cells above.
See the attached spreadsheet.
IF that's not what you want--or some variation on that--then you'll need to be a LOT clearer in your request.
