Labour Analysis Headcount

Originally Posted by brokenbiscuits

Try the following formula:

=IF(AND($D2="",$E2=""),$F2,IF(COUNTIF($G$1:G$1,$E2)>0,0,IF(COUNTIF(H$1:$R$1,$D2)>0,0,$F2)))

Sorry, original i thought it's correct. With a close look again, at scenario 3 with Feb as end month, Feb should also have the same F.T.E rather than zero out. From Mar, the head count should turn zero.

Can you share how you construct this formula at the beginning?

thank you.