Countifs, If SUM of range is between two values.

Hi All,

I have the following formula:
=IF((COUNTIFS(data_sheet!U:U,Monthly_Report!H10))>166,0,COUNTIFS(data_sheet!U:U,Monthly_Report!H10,data_sheet!BN:BN,"Premier"))

This formula counts values on my data sheet based on the specified criteria. I have this broken ito 3 section, each section that needs to be summed.

Section 1 can not be greater than 165, if it is all the values in the range needs to be reset to 0
Section 2 can not be greater than 190, but at the same time can not be less than 166, else is need to be reset to 0. How would I adjust the above mentioned formula to check these criteria?

Thanks

Hi there,

This is almost what I am looking for, however, I need the check to be applied to the first part of the countifs, so it will count them regardless of the value, I.e premier, etc. and then if this total count is between the range due a count based on value.

I found my own solution using what you had previously suggested. The solution:
=IF(AND(COUNTIFS(data_sheet!U:U,Monthly_Report!H10)>=166,

COUNTIFS(data_sheet!U:U,Monthly_Report!H10)<=190),

COUNTIFS(data_sheet!U:U,Monthly_Report!H10,data_sheet!BN:BN,"Premier"),0)