Sumproduct Array Formula

DougDodge
DougDodge used Ask the Experts™
on
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.
Test-Workbook.xlsx
Comment
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.
=SUMPRODUCT(($C$5:$C$140<=AK$4)*($C$5:$C$140>AJ$4)*INDEX($F$5:$AH$140,,MATCH($AI724,$F$4:$AH$4,0)))

Open in new window

Test-Workbook.xlsx

Author

Commented:
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