SUMIF question

nilsr 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

You could get a precise solution much faster with a file (w/out sensitive data).

This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

It is also helpful to know the operating system and Excel version, as different approaches may be required depending on the version and OS.

At the same time, I would like to draw your attention to the fact that if you are on English excel and use English formulas you would have to have (,) instead of (;) in your formula.
Here is a small example: =SUMIFS($B$7:$B$37,$I$7:$I$37,$D$7:$D$37)