SUMIFS with multiple conditions

Hi there,

I'm trying to count some values, according to multiple conditions.

This is a discription of my data:

A:A Date
B:B Discription
C:C Code
D:D Team
E:E Each cell is this column has the value of 1, so these can be summed to count

For each day I want to count the, accordion to:
Team = "Team A"
AND
Discription = "correction" of "vallidation" OR Code = 122, 135 or 165

I figured that a formula without the code condition could be
=sum( sumifs( E:E , D:D,"Team A", B:B, {"correction","vallidation"}))

Then I tried to add te code condition:
=sum( sumifs( E:E , D:D,"Team A", B:B, {"correction","vallidation"} , C:C,{122,135,165}))

This does not return the right values, because there is an AND relation between discription and code, instaid of an OR relation.

Can anybody help me with a formula that solves this problem? That would help a lot!

Thank you!

Thanks for the reply. Unfortunally this returns an error: #NAME?

Jeez, my bad... I'm using a Dutch version of Excel, and made a typo in the translation....

Thanks! Works perfectly

So, =SUMPRODUCT(E:E,--(D:D="Team A"),--(((B:B="correction")+(B:B="vallidation")+(C:C=122)+(C:C=135)+(C:C=165))>0)) does the job, but I have an additional probrem;

The discription condition (B:B) should be; "contains" correction or vallidation, for example 'the correction of....'

I tried =SUMPRODUCT(E:E,--(D:D="Team A"),--(((B:B="*correction*")+(B:B="*vallidation*")+(C:C=122)+(C:C=135)+(C:C=165))>0)), but that doen't work...

Any ideas?