- Joined
- Apr 13, 2011
- Messages
- 1
- Reaction score
- 0
Good afternoon,
I am trying to create a turnover report in which I deduct workers from one company and add them to the next one (see attachment).
For example: If my worker moves in a specific month (eg. April, the month is determined by 'Sheet1' cell F1) from company 1 to company 2, then I want on 'Sheet1' the value -1 in cell A4 and a +1 in cell B4, etc. So I need a formula that looks for all workers in April who moved from one company to the next one and deduct those numbers from the particular cell in 'sheet1' (A4, B4, C4 or D4) and add it to the new company's cell in 'sheet1'.
I hope this makes sense and that someone can help me. I tried the COUNTIF function, but that doesn't work with the month variable in it. And I couldn't get the SUMPRODUCT to work either.
Thank you so much for your help!!!!!
View attachment Tover.zip
I am trying to create a turnover report in which I deduct workers from one company and add them to the next one (see attachment).
For example: If my worker moves in a specific month (eg. April, the month is determined by 'Sheet1' cell F1) from company 1 to company 2, then I want on 'Sheet1' the value -1 in cell A4 and a +1 in cell B4, etc. So I need a formula that looks for all workers in April who moved from one company to the next one and deduct those numbers from the particular cell in 'sheet1' (A4, B4, C4 or D4) and add it to the new company's cell in 'sheet1'.
I hope this makes sense and that someone can help me. I tried the COUNTIF function, but that doesn't work with the month variable in it. And I couldn't get the SUMPRODUCT to work either.
Thank you so much for your help!!!!!
View attachment Tover.zip