Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 17 Mar 2017 20:55:39 +0100Assume data in column A repeats the row number. Column B contains random data. What formula (in column C beyond row 10) would yield the average of the last 10 values in column B?https://ask.libreoffice.org/en/question/90462/assume-data-in-column-a-repeats-the-row-number-column-b-contains-random-data-what-formula-in-column-c-beyond-row-10-would-yield-the-average-of-the/ Spread sheet
aceking370Fri, 17 Mar 2017 20:55:39 +0100https://ask.libreoffice.org/en/question/90462/Average of last x rows in Calc?https://ask.libreoffice.org/en/question/8556/average-of-last-x-rows-in-calc/In a spreadsheet to which new rows are added continually, is there a way to write a formula that'll automatically calculate the average (or anything else, for that matter) of the values in the last x rows of a specific column?OMon, 03 Dec 2012 09:55:59 +0100https://ask.libreoffice.org/en/question/8556/