Hi.
Yes it is. May some clarification though.
Is it the prior 7 days like a rolling average or the days say Monday to
Sunday, every Sunday.
Are you only averaging days where production exceeds 10000, so in your
1st example day 1 is the only day exceeding 10000 so the average=10000
and in your second example 4 days exceed 10000 so those 4 are averaged.
Steve
On 2015-03-10 19:20, David Love 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.
DL
--
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
