MacroNovice2
New Member
- Joined
- Feb 19, 2019
- Messages
- 4
Could someone please help me to write a new formula. Currently I have this:
=SUMPRODUCT(('Timing Plan'!$V$8:$V$1032)*('Timing Plan'!$P$8:$P$1032=$C13)*('Timing Plan'!$H$8:$H$1032<BX$7)*('Timing Plan'!$I$8:$I$1032>=BX$7+1))
$V$8:$V$1032 = average required hours
$P$8:$P$1032=$C13 = Person responsible
$H$8:$H$1032<BX$7 = start date of task
!$I$8:$I$1032>=BX$7+1) = task deadline
This averages out the allocated hours to a ask from the start to end date. There is a column M that allows you to enter the hours completed to date. I would like the hours to readjust over the remaining days if for example more hours were consumed one week or if less hours were consumed another week.
=SUMPRODUCT(('Timing Plan'!$V$8:$V$1032)*('Timing Plan'!$P$8:$P$1032=$C13)*('Timing Plan'!$H$8:$H$1032<BX$7)*('Timing Plan'!$I$8:$I$1032>=BX$7+1))
$V$8:$V$1032 = average required hours
$P$8:$P$1032=$C13 = Person responsible
$H$8:$H$1032<BX$7 = start date of task
!$I$8:$I$1032>=BX$7+1) = task deadline
This averages out the allocated hours to a ask from the start to end date. There is a column M that allows you to enter the hours completed to date. I would like the hours to readjust over the remaining days if for example more hours were consumed one week or if less hours were consumed another week.
