+ Reply to Thread
Results 1 to 3 of 3

Count number of Dates in a range that match Year and month

  1. #1
    Registered User
    Join Date
    01-13-2015
    Location
    uk
    MS-Off Ver
    Various but mainly PC Office 2010
    Posts
    4

    Count number of Dates in a range that match Year and month

    Oh so I have a table with Years down one side and months along the top

    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    2006
    2007
    2008
    2009
    2010
    2011
    2012
    2013
    2014

    Then a range of 400 different dates, and basically I want a count formula that will count number of those dates that are in Jan 2006, Feb 2006 etc
    Am Trying something with sumproduct or countifs and year/month functions but cant quite get it to work.
    Anyone got a quick solution, have also tried pivottable but again cant quite get it.
    Thanks

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Count number of Dates in a range that match Year and month

    If that table begins in A1 (Jan is in A1) AND your months are just text strings like "Jan" "Feb" etc..

    This will count Jan 2006

    =COUNTIF(INDEX(A2:L10,0,MATCH("Jan",A1:L1,0)),2006)

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Count number of Dates in a range that match Year and month

    so if your months are in row 1 and years in column A while dates are in sheet2 column A try in B2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy down and right
    Best Regards,

    Kaper

+ 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. [SOLVED] count number of times a text appeared in a month in given range of dates and names
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2014, 08:27 AM
  2. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  3. Replies: 2
    Last Post: 06-21-2012, 08:17 PM
  4. count no. of dates in a column that falls on certain month & year
    By RawSugar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2005, 06:05 PM
  5. count dates within range by year and month
    By Isaiah25 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-04-2005, 06:06 PM

Tags for this Thread

Bookmarks

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