+ Reply to Thread
Results 1 to 2 of 2

Counif using dates

Hybrid View

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    54

    Counif using dates

    So I am trying to use a countif function with dates. So I need to count up by month for example every time January 14 then February 14 and so on, This will also span multiple years.

    Then I need to use a countifs to go by month and then by a value.

    =Countif(C:C,">=1/1/2014)-countif(C:C,">=2/1/2014") is what I have now, I was just wondering if there was a way to stream line the process to make using countifs possible in the next column

  2. #2
    Registered User
    Join Date
    11-15-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Counif using dates

    I found another way to do the first part that I need the formula looks like this
    =SUMPRODUCT((TEXT($C$2:$C$65489,"mm-yyyy")="01-2014")*1

    Now I need to use a countifs to include if in C the date is any time in January and if in G the value is 1

+ 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. Counif for row
    By amarrb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2011, 07:45 PM
  2. counif v sumproduct
    By khalid79m in forum Excel General
    Replies: 1
    Last Post: 12-28-2006, 10:16 AM
  3. Counif
    By moglione1 in forum Excel General
    Replies: 5
    Last Post: 09-23-2005, 09:05 AM
  4. counif but not all the cells
    By thanks in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. counif but not all the cells
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM

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