Re: [libreoffice-users] selecting cells in calc sheet

At 21:00 24/04/2015 +0100, Pete Nikolic wrote:
> I need to be able to select the last 3 in a series of cells that 
> change on a weekly basis so in
> week 1: there would be 1 cell - no action
> week 2: 2 cells - no action
> week 3: 3 cells - sum three cells
> week 4: 4 cells - sum last three
> week 5: 5 cells - sum last three
> and so it goes on for 8 weeks always just summing the last 3 cells 
> in the series then divide by 3 subtract 30 = result ..

I'm guessing that you want separate results for each week, not just a 
single result - so that in week 5, for example, you would have three 
results, not one. Let's imagine your data is in column A, starting in 
A1. In B3, insert:
=AVERAGE(A1:A3)-30
and fill down the column.

If you want to suppress the display in B cells for which there is not 
yet an A-cell vale, try something like:
=IF(A3=0;"";AVERAGE(A1:A3)-30)

I trust this helps.

Brian Barker


--
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