My formula does not work correctly because it doesn't count all instances from Sheet A and I'm not sure why.
Sheet B contains my Date Criteria & formula to count the instances:
A16 = 25 May 2015
B16 = 29 May 2015
=COUNTIFS(Sheet A!$J$5:$J$5000,">="&A$16,Sheet A!$J$5:$J$5000,"<="&B$16,Sheet A!$D$5:$D$5000,"Bug")
Sheet A contains all the raw data:
D = Types of Issue (Bug, Improvement, Task, etc)
J = Created Date
Why would it count 16 out of 27?
Sheet B contains my Date Criteria & formula to count the instances:
A16 = 25 May 2015
B16 = 29 May 2015
=COUNTIFS(Sheet A!$J$5:$J$5000,">="&A$16,Sheet A!$J$5:$J$5000,"<="&B$16,Sheet A!$D$5:$D$5000,"Bug")
Sheet A contains all the raw data:
D = Types of Issue (Bug, Improvement, Task, etc)
J = Created Date
Why would it count 16 out of 27?