Sorry if I am not clear about the problem. Can you clearify one thing for me so that I can try helping you with your problem?

The criteria columns seems exhaustive with the dummy set data. Can you please explain it for me?

As far as I can think, sumproduct with '+' for multiple criteria in a criteria range is the solution for the problem.

Br,