Hello, I have a database that captures all of the management information for technical issues captured. One column, BA, calculats the amount of time from the start of a tech issue to when the support team was contacted. I do this for multiple regions. So I created a countifs formula that follows:
=COUNTIFS('IM Raw Data'!$H:$H,"HBUS",'IM Raw Data'!$BA:$BA,"15:00>=30:00",'IM Raw Data'!$J:$J,">="&"01/01/2014",'IM Raw Data'!$J:$J,"<="&"01/31/2014")
Bsically the formula first looks for the correct region, in this case HBUS, then I want to count the number of instances that occur in:
>=15, 30>=15, 60>=30, and >60. Then I am looking for the corresponding beging and ending month dates.
Not sure why this insn't working