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

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 in 2017

Correct :)

> I've added Column E and Column F to be real date value.
> E2 =DATE(2016,MATCH(A2,$G$1:$G$12),B2)
> F2 =DATE(2017,MATCH(A2,$G$1:$G$12),B2)

This turns out to be a problem as I am working with five(5) years of 
data and whilst my example did not shot it there are multiple values 
under each month, even if it is zero.

I don't think five columns of dates is a smart way to do this.
I am rather going to investigate making my date column a rolling year 
numeric month/day for 365 rows, with the columns being divided into years.

Example:

Date    2016    2017    2018
0101    0       1       5
0102    1       0       0
0103    0       5       10
0501    1       0       0
0922    5       1       1
3112    0       1       0

I then reckon use of MATCH, DAYS, COUNTIF and SUM should deliver what I 
seek.

Your thoughts on how to get the rows in a column formatted as Date to 
show a sequential month and day number?

I have Bcc'd you as the message contain an attachment of my existing sheet.

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