+ Reply to Thread
Results 1 to 3 of 3

Count of data by day and month - Event locator

  1. #1
    Registered User
    Join Date
    Arizona, USA
    MS-Off Ver
    Excel 2007

    Count of data by day and month - Event locator


    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. #2
    Administrator JBeaucaire's Avatar
    Join Date
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365

    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.


    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.
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    MS-Off Ver
    2002, 2007:2013

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

    Try something like this...

    Dates in column A
    Conditions in column B

    Last edited by Tony Valko; 07-23-2016 at 01:52 PM.
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count data entered in previous month and last week
    By maxi0009in in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2016, 10:09 AM
  2. Count number of event types occuring by month (SUMPRODUCT?)
    By iswizzle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2015, 03:04 PM
  3. Count in Pivot Table by Month - with random dates in data source
    By lindsgray in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-08-2015, 04:49 PM
  4. Count number of networkdays for each month in a multi month period
    By dreddster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 11:12 AM
  5. Replies: 4
    Last Post: 11-07-2012, 04:02 PM
  6. Using MONTH() formula's to count data?
    By dandavis1 in forum Excel General
    Replies: 7
    Last Post: 03-25-2010, 10:17 AM
  7. Warehouse product locator suggestions..
    By trainee01 in forum Excel General
    Replies: 8
    Last Post: 12-08-2007, 06:35 AM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1