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")

E	F	G
Answer 1	Answer 2	Status
YES	NO	GREEN
YES	YES	Out of Scope
NO	NO	AMBER
NO	YES	COMPLETE

<tbody>
</tbody>

 

[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