politicalangel
New Member
Hi,
I have 2 tables- one that has the key ( tells us if an employee is term and active) and this drives the calculation table to give me the amount per month.
What I need is a formula by each month that will only give me the active employees of that year. So for example in the month of Feb-- it should only sum the total of only the active employees at year end(Dec). If they were term. within the year I would not need them included.
Thanks...
See attached spreadsheet for sample
I have 2 tables- one that has the key ( tells us if an employee is term and active) and this drives the calculation table to give me the amount per month.
What I need is a formula by each month that will only give me the active employees of that year. So for example in the month of Feb-- it should only sum the total of only the active employees at year end(Dec). If they were term. within the year I would not need them included.
Thanks...
See attached spreadsheet for sample