Sumif Help

[redhouse23]

Hello,

I am trying to sumif a column based on multiple criteria. However, the formula requires that I drag it across hundreds of columns, which in turn means I need to add a new criteria for each column I drag the formula across (see image "Original").

How can I write the same formula, but in a way that I don't have to keep manually adding the new column/criteria into the formula for each column I drag it over? Conceptually, I'd like to get to something like I have in image "New". Obviously, the formula in image doesn't work, but what can I do to get the same result?

For both image examples, the result should be 100. Please let me know if my explanation of the problem is unclear. I hope the images will do most of the "talking" for me. Thanks!


ORIGINAL

NEW

 

[redhouse23]

Here are the same examples if I drag the formula down some columns. You can see that I'd have to keep manually adding a column to the formula in the "Original" formula. How can I avoid this?

ORIGINAL V2

NEW V2

 

[petertenthije]

Ignore, I misunderstood the data.

 

[redhouse23]

Any ideas? Feel free to ask questions if I wasn't clear.

 

[redhouse23]

One more bump.