Michael,
Thank-you for the time and response
On 08/05/2017 08:54, Michael D. Setzer II wrote:
Not sure if I fully understand what you are looking at,
but here is what I have attempted.
Assuming you column data is:
A is month
B is day of Month
C is the rain on day in 2016
D is the rain on day
On 07/05/2017 23:48, Remy Gauthier wrote:
Hi,
If you have one row per day of the year, you can find out easily where
the row corresponding to "TODAY()-1" is located by finding out the
number of days between Jan 1st of that year and "yesterday". This would
be something like (you may need to
y to: hyl...@conacher.co.za
To: LibreOffice Users <users@global.libreoffice.org>
From: "Hylton Conacher (ZR1HPC)"
<hyl...@conacher.co.za>
Subject:[libreoffice-users] COUNTIF / DAYS / ?
Date sent:
Hi.
Is the rainfall data regular (every day) or sporadic.
If sporadic, is the amount of rainfall cumulative since the previous date.
I also take it that you want 2 outputs. The total amount of rainfall
over the desired period and the number of data points on which rainfall
was recorded over
Hi,
If you have one row per day of the year, you can find out easily where
the row corresponding to "TODAY()-1" is located by finding out the
number of days between Jan 1st of that year and "yesterday". This would
be something like (you may need to adjust based on the heading of your
column(s)):
Hi,
I have a spreadsheet I use to draw graphs and extract information about
the rainfall in my area for the last two years.
I need to create a formula that will count how many days it rained
between the start of the year, both last year and this year, so I can
compare the amount of rainfall