Ignore result IF

[Adrac]

Hello all,

I have 3 columns with YES NO in first 2 columns and status in the 3rd.
I'm using COUNTIF yes in both first 2 columns but I want to ignore the row if the status is 'Out of Scope' OR 'Complete'

=COUNTIF('B. General' !$E:$F, "yes")

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD]Answer 1[/TD]
[TD]Answer 2[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]GREEN[/TD]
[/TR]
[TR]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]Out of Scope[/TD]
[/TR]
[TR]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]AMBER[/TD]
[/TR]
[TR]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]COMPLETE[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Look at the Countifs function.

https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

 

[Adrac]

Hello Scott,

This doesn't show how to take values out of the equation.

 

[Scott T]

Countifs lets you have multiple criteria.

Excel 2010
	E	F	G
1	Answer 1	Answer 2	Staus
2	yes	No	Green
3	yes	yes	out of scope
4	No	No	amber
5	No	yes	complete
6	yes	yes	amber
7	yes	yes	out of scope
8	yes	yes	Green
9
10	2	count
Sheet1

Cell Formulas
Range	Formula
E10	=COUNTIFS(E2:E8,"yes",F2:F8,"yes",G2:G8,"<>out of scope",G2:G8,"<>complete")

 

[Adrac]

Thank you Scott that's perfect