Countif between 2 dates with multiple criteria

I am trying to count how many 'active' employees I have week to week, with 2 other criteria.

sheet1 has the data and over time 4 employees have been 'term' (terminated).

sheet2 is where I need the formula. So, essentially I need a running total of active employees for the week end for rep/Lead/Sup (criteria 1) and ORG (criteria 2) in columns B,c, and d

You can ignore columns F:I, I'll just copy/paste the formula and adjust as necessary. Thanks for the help.

Thanks for the response. This is close, but doesn't work entirely.

I should have been more clear. This will be an ongoing count, so when I term or active additional employees, the previous weeks counts change but I need the counts to remain as they were.

For example, if I add a active/rep/org for week end 12/20, the previous weeks count will go up by 1 too. Can we somehow adjust the formula so instead of doing a > on the term week end date, we use count of active or term as the criteria instead?

correct. I added 2 columns and reattached.

when I add a new entry all the previous weeks still + 1

What's happening is the following:

I did adjust the formulas to include a longer range. When I add a date in the week end column, it works good (column H). The issue is when I add a new entry with a later date. For example, I entered a new employee with a hire date of 1-3-2016. The previous week end counts all go up by 1, and I only want the week end count of the appropriate weekend to go up. All the previous week ends should stay the same.

please see attached. thanks for the help