Hello,
Re the attached, I am looking for a formula that will populate cells H2:S7, and give me the number of staff each month, in each Region (eg Home, Americas...), accounting for new starters and leavers.
I am trying to use COUNTIFS, SUMPRODUCT, but can't get it to work.
The yellow cells are examples of the correct final figures.
I will also need to do this for summing the SAL (col E), presumably I can use the same principles for the count?
Does anyone have any ideas?
Thanks
Rich
Bookmarks