Sumproduct Array Formula

DougDodge used Ask the Experts™
The attached sheet has test data for what I am trying to accomplish. Range F4:AE4 has one set of criteria. That criteria should match AI724:AI750. The Date range is C5:C140. The criteria for that range is AK4:DF4 is one week increments. The values to sum are in range F5:AH140. So there are multiple criteria for the SumProduct. It all seems simple enough, but maybe it is weekend mind block. And help here would be greatly appreciated.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use this formula in AK724, copy and paste as formula down and across.
It is not an array formula.

Open in new window



Works perfectly, thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial