Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 28 Nov 2016 16:54:11 +0100average of sumshttps://ask.libreoffice.org/en/question/82687/average-of-sums/Let's say I have some data on columns B through E that I want to average as follows:
- for each row: sum the four columns
- then take the average such sum
Do I *have* to get another column for the sum and then take the average of that column or is there a more direct approach? Because pulling ``=SUM(...)`` down ``500'000`` rows **does** take a while. DiesNutsMon, 28 Nov 2016 16:54:11 +0100https://ask.libreoffice.org/en/question/82687/