Countifs and ranges

Occasional Visitor

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

1 Reply

@klesiecki 

Untested.

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