I need to count how many days appear between 2 dates, but only those that have a value in another cell. Is this possible. COUNTIFS(E2:R2,">="&Sheet1!E7,E2:R2,"<="&Sheet1!F7) is only counting the number of days between 2 dates, I want to go a step further find the days between 2 dates but only count them if there is a corresponding entry in row 3 (e3:r3)