2015 Archives by date, by thread · List index

Re: [libreoffice-users] Calc formula ...

```David Love <zed@zed.net.nz> 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: users+unsubscribe@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
```