Hi,
If I understand your question correctly, you need to be able to
"automatically" index in your data matrix, for total sum and number of
days. To achieve this, I would change the worksheet in the following
manner:
Formula in D2: =SUM(OFFSET(D3;0;0;MATCH(TODAY()-1;$C$3:$C$368;0);1))
This formula
Enviado con AquaMail para Android
http://www.aqua-mail.com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List
On 04/27/2018 11:45 PM, Tim-L wrote:
I just installed Ubuntu-Mate 18.04LTS
I looked and they installed LibreOffice 6.0.3.2.
Though there are issues with Ubuntu's 18.04 OS, it is nice to see an
up to date LO at an OS install time.
Well, I just upgraded - not clean install - and it kept
On 28-4-2018 09:14, Luuk wrote:
> On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote:
>> Hi,
>>
>> I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable
>> me to draw graphs based on rainfall received per year, up until the
>> date prior to today. The figures also allow me to
Morning Brian,
Thanks for the reply.
On 2018/04/27 20:20, Brian Barker wrote:
At 18:04 27/04/2018 +0200, Hylton Conacher wrote:
I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable
me to draw graphs based on rainfall received per year, up until the
date prior to today. The
On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote:
> Hi,
>
> I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable
> me to draw graphs based on rainfall received per year, up until the
> date prior to today. The figures also allow me to compare current
> rainfall to date to the