Countifs and ranges

[klesiecki]

I need a particular field to count any entries in the previous set of columns between 40 and 59.  I can do =COUNTIFS(AZ3:BI3,">=60") but I need it to be >=40 and <=59.  Not sure how to accomplish this.

KL

[#2]

@klesiecki 

Untested.

=COUNTIFS(AZ3:BI3,">=40",AZ3:BI3,"<=59")