Sumif - summing under conditions

[nn992]

Hello everyone,

I want to automatize my work with excel, but sumif function is giving me small issues. I provided a screenshot to explain you my problem.



Can you please tell me how can I tell excel to sum all the values from "new errors" column but only if the event type is "ICH"?

You can see the formula I wrote but it doesnt work...

Thanks in advance...

 

[SawdustCollector]

Try this:

=SUMIF(C8:C415,"ICH",D8:D415)

 

[stumac]

Your sum range and criteria are the wrong way round, however you also seem to have numbers stored as text... if you cannot change these to be stored as numbers then something like:

=SUMPRODUCT((C8:C415="ICH")*(D8:D415))

Should work for you.