Brian Barker <b.m.bar...@btinternet.com> wrote: > 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. > > Not really! > > 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!
Ha! I constructed a table, as you suggested and, yes, it does meet my requirements. Thanks for the suggestion, Brian. David -- David Love Dogs wag their tail with their whole heart. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
