At 10:28 11/03/2015 +1300, David Love wrote:
What I want, in simple terms, is to determine the average number of
steps I am taking every week. Hopefully, this explanation will
answer the questions reaided.
I think you've confirmed that the 10000 figure is irrelevant in the
calculation. But your earlier statements that "if day 1 reaches a
production of 10,000 units I want this figure entered" and "If days
1+2+3+4 total, say, 42,500 I want ... to show the average of 10,265"
both indicate that the required result does not depend on other daily
values. These contradict the idea that you simply want the true
average of all seven values.
Unsurprisingly, you can calculate averages using the AVERAGE() function.
Incidentally, doesn't all this cry out for a table instead of a list?
Put a week date (or date range) in column A, as you suggest. Enter
your data for the days of that week in columns B to H of the same
row. It's then particularly simple to calculate averages in column I.
At the bottom of the columns, you could calculate averages for each
weekday - and perhaps discover that you need to be more active on Thursdays!
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc formula ... · Steve Edmonds
Re: [libreoffice-users] Calc formula ... · David Love
- Re: [libreoffice-users] Calc formula ... · Brian Barker
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy