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.
Bookmarks