Using <= in countifs statement

Joined
Jan 22, 2018
Messages
4
Reaction score
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?
 

Attachments

  • Book1.xlsx
    11.6 KB · Views: 174
Joined
Jan 22, 2018
Messages
4
Reaction score
1
Figured it out, forgot the &
countif(Table2[Created],"<="&E2)-countif(Table2[Resolved],"<="&E2)
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top