Using <= in countifs statement

Discussion in 'Excel' started by Bcallen96, Jan 22, 2018.

  1. Bcallen96

    Bcallen96

    Joined:
    Jan 22, 2018
    Messages:
    4
    Likes Received:
    1
    I am trying to count the differences in the instances between two columns.
    The formula I am using needs to be able to count the instances of before or equal to a date listed in a separate reference cell
    I have attached a sample data table

    What I am trying to accomplish is to obtain a daily running total of tickets not resolved. I think something like this would accomplish the task but get error when I try it - countif(Table2[Created],<=E2)-countif(Table2[Resolved],<=E2)

    What am I doing wrong?
     

    Attached Files:

    Bcallen96, Jan 22, 2018
    #1
    1. Advertisements

  2. Bcallen96

    Bcallen96

    Joined:
    Jan 22, 2018
    Messages:
    4
    Likes Received:
    1
    Figured it out, forgot the &
    countif(Table2[Created],"<="&E2)-countif(Table2[Resolved],"<="&E2)
     
    Bcallen96, Jan 22, 2018
    #2
    Ian likes this.
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.