If Statment Based on Fault Of

[jal0315]

Morning,

I'm trying to build an if then statement to count the occurances of the "Fault Of" when pertaining to quality problems. Below is my current formula that counts all occurances no matter what.

=SUMPRODUCT(--ISNUMBER(MATCH('IR Detail'!$G$1:$G$10586,{"L1","Endfolds"},0)),--('IR Detail'!$A$1:$A$10586>=A4),--('IR Detail'!$A$1:$A$10586<a5))

What I need to do is add a statement in the formula that only counts occurances if fault of is our companies and not customer. The "Fault Of" column is in the worksheet 'IR Detail' column N. I tried using the count if formula, but these counts must be seperated based on facility.

Is there anything I can add into my current formula so only occurances that our fault of company get counted?</a5))

 

[joelbaby]

<a5))
Instead of COUNTIF, try COUNTIFS. This will allow you to add extra criteria such as "facility".</a5))