Hi, I'm working on trying to use countifs formulas and it seems to be breaking when I do this. I'm trying to count if Column BT equals Current Quarter, then look to Column AR and count the lines that fall between 4/16/18 and 4/30/18. when I put the below formula in, I return '0'. When I remove the Current Quarter criteria then I do return a result, however I don't want that result. As you can see below in the screen shot, It counts the line that has Handoff - Closed in BT and I don't want to count that. I only want the result to return 8 (the ones that have a date range of 4/16 - 4/30 and say Current Quarter)
=COUNTIFS(Dana!$BT$3:$BT$3500,”Current Quarter”,Dana!$AR$3:$AR$3500,">="&DATE(2018,4,16),Dana!$AR$3:$AR$3500,"<="&DATE(2018,4,30))
