Count Between

[dragonmouse]

I'm soooo close. I have items that have been in work for "X" number of days from certian customers. (this is probably really simple but I can't see it):

IF it's simply "less than 30 days" this forumula works GREAT:
=COUNTIFS(S:S,"<30",N:N,"<>Air Force",N:N,"<>Navy",N:N,"<>ARMY"). This formula will return "x" number or widgets for any customer that is NOT Air Force, Navy or Army...However...

IF it's between "31 and 90" days this forumula FAILS somewhere: =COUNTIFS(S:S,"31><90",N:N,"<>Air Force",N:N,"<>Navy",N:N,"<>ARMY")

Obviously the BETWEEN 31><90 is not right.

 

[Eric W]

Try:

=COUNTIFS(S:S,">=31",S:S,"<=90",N:N,"<>Air Force",N:N,"<>Navy",N:N,"<>ARMY")

 

[dragonmouse]

Bingo. That worked. I just wish excel would read my mind a bit more LOL. I was trying for just one step but it needed more. THANK YOU

 

[Eric W]

Happy to help! Thanks for the feedback. ?