Forum Discussion
Solved
Using MS Excel to Calculate Rolling Headcount and Turnover
I have an Excel spreadsheet with columns including: personnel names date started date left (blank cell if still current) duration calculation (=IF( [Date Left] >0, [Date Left] - [Date Started] ...
1) In H2, enter the following array formula confirmed with Ctrl+Shift+Enter:
=SUMPRODUCT(($B$2:$B$11<=G2)*(IF($C$2:$C$11="",G2,$C$2:$C$11)>=G2))
Fill down.
1) In H2, enter the following array formula confirmed with Ctrl+Shift+Enter:
=SUMPRODUCT(($B$2:$B$11<=G2)*(IF($C$2:$C$11="",G2,$C$2:$C$11)>=G2))
Fill down.
Wow, thank you so much! This is a huge help!