Countifs

[kizzie37]

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)

 

[yky]

Try this:

=COUNTIFS(E2:R2,">="&Sheet1!E7,E2:R2,"<="&Sheet1!F7,E3:R3,"<>")

 

[kizzie37]

That's awesome, thank you!