Countifs

kizzie37

Well-known Member
Joined
Oct 23, 2007
Messages
510
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

Well-known Member
Joined
Jun 7, 2011
Messages
1,444
Try this:

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

Forum statistics

Threads
1,078,283
Messages
5,339,281
Members
399,291
Latest member
Bdbd55

Some videos you may like

This Week's Hot Topics

Top