I need some help with this one. I have dates entered in one column and three possible options (yes/no/?) in another. I am counting the total number of entries per month{counting within a date range} (=COUNTIFS(Assigned!A2:A3000,">="&Tracking!A2,Assigned!A2:A3000,"<="&Tracking!B2)). What I need to do in another column is track the total number of entries per month that also is marked "yes" in another column. I have tried combining the previous formula with (COUNTIFS(Assigned!A2:A3000,"yes") but I can not get it to work right. How do I combine these two formulas so I can count entries within a date range only if they answered "yes" in another column?????
Bookmarks