Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Date occurance (2000/2003)

    I need a formula to count the dates in a column, that correspond with a location within a given month. I have attached a spreadsheet. the date/location list is on sheet1 and the table where I need the formula is on sheet2. I wrestled with sumproduct but I couldn't get it to work. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count Date occurance (2000/2003)

    Enter the following formula in C4 on Sheet2:

    =SUMPRODUCT((Sheet1!$B$4:$B$47=$B4)*(TEXT(Sheet1!$ C$4:$C$47,"mmmm")=C$3))

    Fill down, then right (or fill right, then down). Note the use of absolute and relative references.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Date occurance (2000/2003)

    That's just what I needed. I am going to have to read up on the test function. Thankyou very much.

Posting Permissions

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