Re: [libreoffice-users] COUNTIF / DAYS / ?

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 that period.

Steve

On 08/05/17 07:55, Hylton Conacher (ZR1HPC) wrote:
> 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