IF statement with "AND"

[Hazman_08]

Hi all,

I have a formula =COUNTIF(G2:G100,"Yes"), which I need to modify to only count where, for example, value in G7 is "Yes" AND value in H7 is not "Complete". Column H has a dropdown with 5 options.

I imagine there needs to be an AND statement added somehow, just not sure.

 

[DanteAmor]

Try:

Dante Amor
	G	H	I
1
2	Yes	Complete	3
3	No	Complete
4	Yes	In Progress
5	Yes	In Progress
6	Yes	In Progress
7	No	Complete
Hoja3

Cell Formulas
Range	Formula
I2	I2	=COUNTIFS(G2:G100,"Yes",H2:H100,"<>Complete")

 

[Hazman_08]

Try:

Dante Amor
	G	H	I
1
2	Yes	Complete	3
3	No	Complete
4	Yes	In Progress
5	Yes	In Progress
6	Yes	In Progress
7	No	Complete
Hoja3

Cell Formulas
Range	Formula
I2	I2	=COUNTIFS(G2:G100,"Yes",H2:H100,"<>Complete")

Perfect. Thanks, legend.