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?
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?