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 that was received during that time frame.
The example below is a sample dataset that shows how much rainfall was
received in 2016 or 2017, on each of the four days
Example:
Month Day 2016 2017
Jan 1 0 15
Feb 29 1 0
May 6 0 1
Sept 22 15 5
From this we can determine that 16mm of rain fell in 2016 over 2 days.
Likewise we can determine that 21mm of rain fell in 2017 but over 3 days.
Today is the 7th of May 2017 and I would like a formula to work out how
many days the rainfall received between(and incl) 2016/01/01 and the day
before TODAY last year. The answer for 2016 is 1 i.e. it only rained
once between the dates specified, however the answer for 2017 is 16 as
it rained twice between TODAY-1 and 2017/1/1. I had thought of using
COUNTIF or DAYS or =COUNTIF(C2:SUM(TODAY()-1,">0")), however the problem
is that I do not have a single date column, but three.
This formula will allow me to create a graph showing how much rainfall
had fallen last year compared to this year between the beginning of the
year(01/01) and the day prior to Today.
I had thought of converting the first two columns into a single and
having the text name of the month with each successive line being a new
date in that month until the month changed, however I was unable to get
it to work i.e. automatically change month after 31 days in January to
read February 01.
As you can imagine I have 367 rows of data per year, mostly with 0 as a
value, however there are odd days it does rain.
Any comments, and if you want the original spreadsheet, just yell where
to put it i.e. Nabble etc.
Regards
Hylton
--
To unsubscribe e-mail to: users+unsubscr...@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