CountIF formula with multiple conditions

[janema]

=COUNTIF(MASTER!$AT$4:$AT$1000,">.80")-COUNTIF(MASTER!$AT$4:$AT$1000,"<.90")

I'm trying to get excel to count a column if value is greater than 80% but less than 90%. What is wrong with my formula? It comes back with way too many so I know it's incorrect.

 

[iggydarsa]

=COUNTIF(MASTER!$AT$4:$AT$1000,"<.90")-COUNTIF(MASTER!$AT$4:$AT$1000,"<.80")

 

[DanteAmor]

Try:

=COUNTIFS(MASTER!$AT$4:$AT$1000,">.80",MASTER!$AT$4:$AT$1000,"<.90")

 

[janema]

Try:

=COUNTIFS(MASTER!$AT$4:$AT$1000,">.80",MASTER!$AT$4:$AT$1000,"<.90")

Thank you so much! I can't believe I missed that. I completely forgot about COUNTIFS.

 

[janema]

=COUNTIF(MASTER!$AT$4:$AT$1000,"<.90")-COUNTIF(MASTER!$AT$4:$AT$1000,"<.80")

That would pull less than 80% but need it greater.