Results 1 to 3 of 3

Thread: Countif (2000)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Countif (2000)

    I have a list of dates in column A (>10,000). I would like to count the number of, say, January 1sts. I tried "=countif(a:a,and(month(a:a)=1,day(a:a)=1))", but it returned a zero. Any ideas?
    Thanks

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

    Re: Countif (2000)

    COUNTIF (and SUMIF) don't work with multiple criteria. You must use SUMPRODUCT or array formulas instead, for example:

    =SUM((DAY(A1:A20000)=1)*(MONTH(A1:A20000)=1))

    entered as an array formula (confirm with Ctrl+Shift+Enter)

    Note: you can't use A:A in this formula.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Countif (2000)

    Thanks to Hans and Steve.

Posting Permissions

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