Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 22 Sep 2017 18:46:56 +0200How can I reduce the number of cell in a sheet by taking the average of a set number of cellshttps://ask.libreoffice.org/en/question/132236/how-can-i-reduce-the-number-of-cell-in-a-sheet-by-taking-the-average-of-a-set-number-of-cells/I have a spreadsheet with about half a million rows in it. For the sake of having the data t calculate Min, max, and average, this is helpful. However this is really hard to read. I want to know how I can take the average of like, a thousand cells at a time and output that to another page. Here is a screenshot of my data.
![](https://i.imgur.com/y7VqtkO.png)
In the screenshot data is logged multiple times a second, I'd like to reduce that to maybe, 50 times a second.
Any help is greatly appreciated!
(*edit:* activated screenshot)VigilanceFri, 22 Sep 2017 18:46:56 +0200https://ask.libreoffice.org/en/question/132236/