Forum Discussion
Solved
COUNTIF Dates within dates plus condition.
Hi, I´m struggling a bit with the formula to calculate my conditions. I´ve attached an example file to giv an understanding. My conditions are two date columns (A & B) and one date row (H6:...
In the attached file, the formula in H1 is:
=COUNTIFS($A$8:$A$334,"<="&H$6,
$B$8:$B$334,">="&H$6,
$C$8:$C$334,"x")The formulas in H2:H4 are similar, then copied across columns until Column ID.
In the attached file, the formula in H1 is:
=COUNTIFS($A$8:$A$334,"<="&H$6,
$B$8:$B$334,">="&H$6,
$C$8:$C$334,"x")
The formulas in H2:H4 are similar, then copied across columns until Column ID.
- You’re very much welcome!