# Count of data by day and month - Event locator

1. ## Count of data by day and month - Event locator

Hello,

I have a list of dates over the past 26 years for when certain weather events have occurred. I.e. 8/14/1989, 8/16/1989, 10/20/1989, 9/15/2006, etc...

I want to be able to make a graph of how often those events have occurred when in the year, but not by year... so in other words I want to know how often a rain event has occurred on July 25 in the past 26 years....

How can I do this???

2. ## Re: Count of data by day and month - Event locator

I believe you need to expand your data set a little to make this easy.

If DATE is in B2, you can use formulas to pull out the Month and Day in columns C and D.

=MONTH(B2)
=DAY(B2)

Now you have data points that make it simple to create PIVOT TABLEs from. Or even manually create SUMIFS() for your initial results. But Pivot Table seems most useful.

Attach a sample workbook if need more specifics if you have trouble making those edits.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3. ## Re: Count of data by day and month - Event locator

Try something like this...

Dates in column A
Conditions in column B

=SUMPRODUCT(--(TEXT(A2:A20,"mmmd")="Jul25"),--(B2:B20="Rain"))

There are currently 1 users browsing this thread. (0 members and 1 guests)