Hey all,

I'm running into a problem with a certain COUNTIF statement. I have to count the number of agents based on the following criteria:

-What level of agent they are (L1,L2,L3,L4)
-How long they've been tenured (ranges of days: 0-60, 61-90, 91-120, 121+)

So in otherwords, I need to count the L1 agents between 0-60, 61-90, etc. along with the rest of the levels...

I've tried the following:

=COUNTIF(Roster!F:F,">1")-COUNTIF(Roster!F:F,">60")

Which provides me the correct number of agents, but does not take into account the fact that certain agents might be counted incorrectly due to non promotion after a certain date range.

Is there a way to fix this using the above criteria? Thanks.