Results 1 to 8 of 8

Using COUNT(IF(... to count number of months in years

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Melbourne
    MS-Off Ver
    365
    Posts
    13

    Using COUNT(IF(... to count number of months in years

    Hi guys,

    I have a large list of dates and need to count the occurrence of months in given years (so that July 2013 and July 2014 don't cause double ups for example).

    The formula I entered
    "=COUNT(IF(AND(YEAR(C2:C176)=2013,MONTH(C2:C176)=7),C2:C176,0))"
    returns a value of 1 (incorrect). If I take out the AND function and use EITHER MONTH or YEAR the function returns the correct individual values as is needed.

    Any thoughts?

    Regards,
    Abid
    Last edited by Abid123; 01-17-2014 at 01:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count how many months/years have passed?
    By famico78 in forum Excel General
    Replies: 5
    Last Post: 08-24-2017, 10:04 PM
  2. [SOLVED] Count number of specific dates within several years
    By thed85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2013, 12:55 PM
  3. Replies: 3
    Last Post: 08-22-2011, 11:58 AM
  4. Count Number Of Elapsed Months
    By simonyglog in forum Excel General
    Replies: 4
    Last Post: 04-08-2011, 10:34 AM
  5. count number of years 2003 in a range of dates
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2005, 03:06 PM

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