Summing 350 Columns of Daily Hrs to Another Table with Weekly Hours

Notes:
All Tabs are Table Based

Polaris Tab
Import Monday Start date changes weekly, thus changing the Project Week number
Hours data has from Column I to Column MK - where project week and individual dates change based on import start date

CST040 Tab
Friday Week End Date can be changed to consolidate 1 year into Column AB
CST040 sums ATD Hours from P036 Tab and Non P036 Tab - working fine
sums ETC Hours from Non P036 Tab - Working fine

What is not working is summing hours from Polaris tab to add to CST040 by Week

Sample formula on the attachment from Cell AB7 on the Cell AB7 Tab without the Polaris formula. Previously I had a SUMPRODUCT formula that worked but now I can not get it to add - even though I duplicated it the same. See tab called "OLD FORMULA" for a sample. The old formula is no longer relevant due to significant changes on the Non P036 Tab which are summing as expected to CST040).

I am requesting help to determine the formula to add Polaris to the existing formula on AB7.

Screenshots are of very little use.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

It says Microsoft 365 Apps for enterprise
Version 2405 Build 16.0.17628.20006 64-bit.

I get that it is best practice to post a sample file - if I strip the formulas (as they have confidential information built into them) I do not think that would be of any greater assistance. Or am I missing something?

Basically, I need a formula that will add multiple days of hours into weekly hours based on week numbers stored in the column and 1 condition stored on the row which identifies the person/role -

you can mark it as solved using the thread tools dropdown at the top of the post. Incidentally it could be of help to others to post the resolution if appropriate.

Originally Posted by Puddintaine

Please close this post - I resolved the issue with assistance from another source. -

Please share your solution for the benefit of others.