2015 Archives by date, by thread · List index

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

```On Fri, 24 Apr 2015 21:52:47 +0100
Brian Barker <b.m.barker@btinternet.com> wrote:

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

```
```Hi Brian

ok    lets see ..

if we start as will be the case  C3   will contain say 50  (the actual dates are
of little importance )  a month later  C5 will be say 47  and so on every month
the next cell would be C7 then C9 then C11 what i need is to be able to
automatically pick the last 3 cells containing data  so when C9 is filled in then
it needs to automatically choose  C9 C7 C5 and add them then divide by 3  then
subtract  a variable defined on the day   ..

Hope this makes it a little clearer

Thanks Pete .

--
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere.

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