Originally Posted by kalkap

I'm trying to count the number of components that meet 2 criteria from the same column. I've tried various iterations of COUNTIFS but no luck. Column A contains a list of components in which there are numerous duplicates. Column B contains a maintenance outage identifier. Column C contains maintenance tasks (duplicate components because numerous maintenance items). I'm trying to counter the number of components that fall in the same outage identifier where "Refurbish Actuator" will be performed AND of these components also will "Diagnostic Testing" done. "Refurbish Actuator" and "Diagnostic Testing" are within the same column which is where my troubles come into play.

Hopefully this is clear enough to get some help. Thanks in advance.