Hello,
I've got a table like that :
I'd like to fill this table, the column "nb of days" for each months with :
- the forecast column of the current month + the "adjustment" column of previous month that sum for a specific level (if 2 people have the same level they are sum up)
Currently I'm able to do it with the forecast column of the current month only.
The formula I use is :
Any idea on how I can do it ? I tried to play with offset but no luck to do it :'(
I've got a table like that :
![ejTTvVQ.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FejTTvVQ.png&hash=b216f02f5afd0cb7fc4b2b67fab0ef25)
I'd like to fill this table, the column "nb of days" for each months with :
- the forecast column of the current month + the "adjustment" column of previous month that sum for a specific level (if 2 people have the same level they are sum up)
![y129CKA.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2Fy129CKA.png&hash=7890598a5b7f714b6ba2939693902532)
Currently I'm able to do it with the forecast column of the current month only.
The formula I use is :
Code:
SUMPRODUCT(('TimeSheet'!$A$3:$A$7='Facturation'!$A3)*('TimeSheet'!$C$1:$T$1='Facturation'!B$1);'TimeSheet'!$C$3:$T$7)
Any idea on how I can do it ? I tried to play with offset but no luck to do it :'(