Why doesn't this work!
COUNTIFS(DB!$C:$C,"<>"&"",DB!$Q:$Q,OR(DB!$Q:$Q="-",DB!$Q:$Q>Summary!B7),DB!$N:$N,"<="&B7)
I want to say select data where:DB!C:C is not blank;
DB!Q:Q equals "-" OR is greater than B7;
DB!N:N is less than or equal to B7.
What is the proper way to nest this OR statement within the countifs statement?
COUNTIFS(DB!$C:$C,"<>"&"",DB!$Q:$Q,OR(DB!$Q:$Q="-",DB!$Q:$Q>Summary!B7),DB!$N:$N,"<="&B7)
I want to say select data where:DB!C:C is not blank;
DB!Q:Q equals "-" OR is greater than B7;
DB!N:N is less than or equal to B7.
What is the proper way to nest this OR statement within the countifs statement?