David Love <[email protected]> wrote: > Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build > ID 420M0(Build2) > > I have a three column spreadsheet. > > Column A. Date - The dates are consecutive > > Column B. Production - The Production has a daily target of 10,000 units > and each production period is of seven days. > > Column C. a formula every seventh cell. > > Is it possible to construct a formula which will show in the seventh > cell of column C the average for the number of days of production i.e. > if day 1 reaches a production of 10,000 units I want this figure entered > into the seventh cell in column C. If days 1+2+3+4 total, say, 42,500 I > want the seventh cell in column C to show the average of 10,265. In > other words I want the average shown for the actual days of production > each seven day period.
Thank you Steve, Brian and Johnny for your prompt replies. I will work through the suggestions and report back. I should, however, make a confession :-) I used the word "Production" as I wanted members to see this as a "business" rather than a "personal" question. In reality, Column A is the numbers of steps I take each day. Ten thousand is considered to be the number necessary to keep healthy. 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. DL -- David Love Bachelor: A guy who has cheated a woman out of a divorce. -- To unsubscribe e-mail to: [email protected] 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
