[libreoffice-users] COUNTIF / DAYS / ?

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