Spreadsheet: 756076d1637264597-neither-sumifs-nor-sumproduct-working-for-me-shift-project-months
Sheet: Original Sched

 | Source: | Neither SUMIFS nor SUMPRODUCT working for me. (excelforum.com) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | 2 | Months to shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 | Master [NAME]
 | TblSchedule |  |  | mDays allocated per month |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Helper | PRJ | Labour Division | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | TOTAL |  | IP # | Labour Division | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | TOTAL
 |  | PRJ01 | Bids | 2.5 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Bids |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Eng | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Eng | 0 | 0 | 2.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | HR | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | HR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Maint Field | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Maint Field | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Procurement | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Procurement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Project Management | 0 | 0.5 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Project Management | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Security | 0 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Security | 0 | 0 | 0 | 0.5 | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Service Ops | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Service Ops | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ01 | Transformation | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | PRJ01 | Transformation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | Bids |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Bids | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | Eng |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Eng | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | HR |  |  |  |  |  | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 |  |  | PRJ02 | HR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | Maint Field |  |  |  |  |  | 0.7311320754716981 | 0.7075471698113207 | 0.7311320754716981 | 0.7311320754716981 | 0.660377358490566 | 0.7311320754716981 | 0.7075471698113207 |  |  | PRJ02 | Maint Field | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 | 0 | 0 | 0 | 0
 |  | PRJ02 | Procurement |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Procurement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.7311320754716981 | 0.7075471698113207 | 0.7311320754716981 | 0.7311320754716981 | 0.660377358490566 | 0.7311320754716981 | 0.7075471698113207 | 0 | 0 | 0 | 0
 |  | PRJ02 | Project Management |  |  |  |  |  | 1.462264150943396 | 1.415094339622641 | 1.462264150943396 | 1.462264150943396 | 1.320754716981132 | 1.462264150943396 | 1.415094339622641 |  |  | PRJ02 | Project Management | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | Security |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Security | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.462264150943396 | 1.415094339622641 | 1.462264150943396 | 1.462264150943396 | 1.320754716981132 | 1.462264150943396 | 1.415094339622641 | 0 | 0 | 0 | 0
 |  | PRJ02 | Service Ops |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Service Ops | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PRJ02 | Transformation |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | PRJ02 | Transformation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Bids |  |  |  |  |  | 10 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME] | Bids | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Eng |  |  |  |  |  | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851 |  |  |  |  | [NAME] | Eng | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | HR |  |  |  |  |  | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 |  |  |  |  | [NAME] | HR | 0 | 0 | 0 | 0 | 0 | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Maint Field |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME] | Maint Field | 0 | 0 | 0 | 0 | 0 | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Procurement |  |  |  |  |  | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 |  |  |  |  | [NAME] | Procurement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Project Management |  |  |  |  |  | 2.638297872340426 | 2.553191489361702 | 2.638297872340426 | 2.638297872340426 | 1.531914893617021 |  |  |  |  | [NAME] | Project Management | 0 | 0 | 0 | 0 | 0 | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Security |  |  |  |  |  | 0.6595744680851064 | 0.6382978723404256 | 0.6595744680851064 | 0.6595744680851064 | 0.3829787234042553 |  |  |  |  | [NAME] | Security | 0 | 0 | 0 | 0 | 0 | 2.638297872340426 | 2.553191489361702 | 2.638297872340426 | 2.638297872340426 | 1.531914893617021 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Service Ops |  |  |  |  |  | 4.397163120567376 | 4.25531914893617 | 4.397163120567376 | 4.397163120567376 | 2.553191489361702 |  |  |  |  | [NAME] | Service Ops | 0 | 0 | 0 | 0 | 0 | 0.6595744680851064 | 0.6382978723404256 | 0.6595744680851064 | 0.6595744680851064 | 0.3829787234042553 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | Transformation |  |  |  |  |  | 1.099290780141844 | 1.063829787234043 | 1.099290780141844 | 1.099290780141844 | 0.6382978723404255 |  |  |  |  | [NAME] | Transformation | 0 | 0 | 0 | 0 | 0 | 4.397163120567376 | 4.25531914893617 | 4.397163120567376 | 4.397163120567376 | 2.553191489361702 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMPRODUCT SOLUTION (normal formula)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IP # | Labour Division | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Bids
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Eng
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Maint Field
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Procurement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Project Management
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Security
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Service Ops
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ01 | Transformation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Bids
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Eng
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Maint Field
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Procurement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Project Management
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Security
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Service Ops
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | Transformation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bids
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Eng
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Maint Field
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Procurement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Project Management
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Security
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Service Ops
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Transformation