Describe the calculation in plain English and get the nested XLOOKUP-SUMIFS monster back, working, inside Excel itself. Tools built into the spreadsheet can see your real columns; browser ones work from a description of the sheet. Both write and explain macros too. Test the edge cases, because a formula that runs is not a formula that is right.
the tools that earn the verdict — no pay-to-win