J
JGGL
Hello All
I hope you can help me with this:
1. I have 2 dates in different columns and I'm couting the days
between them e.g: b2-a2 = 0 (when both dates are the same)
2. I'm using sumproduct to count the instances when the result of the
formula above is less than 0 days.
And the issue that I'm faceing is when the actual result of the 1st
formula is zero, the sumproduct formula is not couting those zeros
Could you please gelp me with that?
This is the actual sumproduct formula that I put together
=IF($W33="","",SUMPRODUCT(--('QMR Table'!$F$2:$F$1988=$W33)*('QMR
Table'!$BV$2:$BV$1988=$W32),--('QMR Table'!$CX$2:$CX$1988<=$AE29),--
('QMR Table'!$CX$2:$CX$1988<>"")))
the section that I'm concern is the columns of CX
I hope you can help me with this:
1. I have 2 dates in different columns and I'm couting the days
between them e.g: b2-a2 = 0 (when both dates are the same)
2. I'm using sumproduct to count the instances when the result of the
formula above is less than 0 days.
And the issue that I'm faceing is when the actual result of the 1st
formula is zero, the sumproduct formula is not couting those zeros
Could you please gelp me with that?
This is the actual sumproduct formula that I put together
=IF($W33="","",SUMPRODUCT(--('QMR Table'!$F$2:$F$1988=$W33)*('QMR
Table'!$BV$2:$BV$1988=$W32),--('QMR Table'!$CX$2:$CX$1988<=$AE29),--
('QMR Table'!$CX$2:$CX$1988<>"")))
the section that I'm concern is the columns of CX