Help with SUMIF for good karma

My guess after looking at it briefly is that you'd probably benefit from learning the FILTER function, which, nested in a SUM function, might be able to achieve more efficiently what you're trying to do. But without understanding all of the various tables to which you refer, it's hard--I and others here are volunteers, not MSFT employees paid to do this--to make sense of the data and the various tables, and we'd need to have that understanding to being to grasp the purpose of the formula in the first place. That's precisely why a good design is so important (and, yes, I know you get that). It's a bummer to be handed a workbook like this created by somebody else and told to make it work.

Anyway, if you can put into words what this sum is supposed to reflect, where it's coming from, what the criteria are, and so forth, maybe I and others could make some educated guesses. The reason I ask that you put it into words--often one of the best ways to write a formula in the language of Excel is to first write it in normal conversational English. And especially if it's as multi-faceted as this one, that's important for explaining it to an outsider. Otherwise we (the outsiders in this case) first have to reverse engineer the formula that isn't working, create our own understanding, and then try to write a working formula, all with data that also are unfamiliar.