Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Countif criteria

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Essex, England
    Posts
    459
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
    =COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

    Thanks for your time

    GaryB

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 01:05, GaryB wrote:
    I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
    =COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

    Thanks for your time

    GaryB
    you need to put ""'s round the > and and &.

    =COUNTIF(A:A,">"&TODAY())

    It's funny because you did the ">" in your question.
    "Have a good time......all the time"
    Ian Mac

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Essex, England
    Posts
    459
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Doh!! How dumb do I feel?

    Thanks for that Ian

    G

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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