You're in business. The AVERAGE() function does the same thing as the SUM()
function divided by the COUNT() function. I would use AVERAGE() as it is
cleaner (more streamlined).
I'm glad I could help. I use the OFFSET() function myself to dynamically define
ranges of cells. If somebody knows a
The main thing I'm not understanding is whether the formula is to be one fixed
place or if after 3 data points it is in cell X but after 4 data points it is
in cell Y. The solution I gave you applies to the latter case.
For the former case I would use a more complex formula like this using your
You did not correct any of my suppositions so here is my very detailed
recommendation. Note that my quotation marks surrounding text are NOT to be
keyed into the spreadsheet. For the time being I will limit my discussion to
columns A through L and rows 1 through 5.
Starting from scratch with a
Pete,
Pardon me. I'm confused.
When you say C5 (for example) which do you mean, Row 5 in Column C or the fifth
column?
Where is the calculation?
You speak of C1, C3, C5, C7, ... but what about C2, C4, C6, C8, ...?
Here is what I understand (my suppositions):
Row 1 is a ser of column
Am 24.04.2015 um 14:55 schrieb Andreas Säger:
Am 24.04.2015 um 14:08 schrieb Tom Davies:
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are quite a
few advantages to it for serious spreadsheeting work.
Le 23/04/2015 20:39, yahoo-pier_andreit a écrit :
The problem is not new, the solution at present unlikely to be
implemented, see link below for further information :
https://bugs.documentfoundation.org/show_bug.cgi?id=50916
Alex
--
To unsubscribe e-mail to:
Le 23/04/2015 20:39, yahoo-pier_andreit a écrit :
And this :
https://bugs.documentfoundation.org/show_bug.cgi?id=43911
Alex
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting
On 04/24/2015 02:08 PM, Tom Davies wrote:
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are quite a
few advantages to it for serious spreadsheeting work.
Regards from
Tom :)
...mmmh, does it works in
Am 25.04.2015 um 14:43 schrieb yahoo-pier_andreit:
On 04/24/2015 02:08 PM, Tom Davies wrote:
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are
quite a
few advantages to it for serious spreadsheeting work.
On 04/25/2015 11:52 AM, Andreas Säger wrote:
Am 24.04.2015 um 14:55 schrieb Andreas Säger:
Am 24.04.2015 um 14:08 schrieb Tom Davies:
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are quite a
few advantages
Am 23.04.2015 um 21:11 schrieb Brad Rogers:
On Fri, 24 Apr 2015 03:52:24 +0900
Thomas Blasejewicz ny...@hb.tp1.jp wrote:
Hello Thomas,
With a new computer running Windows8.1 I noticed, that files DO NOT open
any longer,
when I (double) click on their names or select them and hit ENTER
11 matches
Mail list logo