Forum Discussion
Solved
SUM formula to accommodate monthly cadence, overlap, and match several attributes?
Hello Excel Community, I would really appreciate the help in creating a SUM formula to accommodate the monthly cadence of the # of units below. Units are grouped yearly but are summed every ...
For such result
formula in B2 could be
=SUMPRODUCT(Cadence_Data!$B$2:$Y$5*(Cadence_Data!$A$2:$A$5=$A2)*(Cadence_Data!$B$1:$Y$1>=B$1)*(Cadence_Data!$B$1:$Y$1<EDATE(B$1,6)))Please see in second sheet attached. You only need to adjust the formula on your actual ranges.
For such result
formula in B2 could be
=SUMPRODUCT(Cadence_Data!$B$2:$Y$5*(Cadence_Data!$A$2:$A$5=$A2)*(Cadence_Data!$B$1:$Y$1>=B$1)*(Cadence_Data!$B$1:$Y$1<EDATE(B$1,6)))Please see in second sheet attached. You only need to adjust the formula on your actual ranges.