How do I count the number of people needed on a project over various days?

**seppopovich** · 06-17-2013, 08:35 AM

Schedule.xlsx Schedule.xlsxAttached is the spread sheet with the following problem:

You have jobs 1-10 which have overlapping days in duration (input duration is in hours). In column M, you are supposed to see the number of men required to work each day (as a cumulative of all projects). I cannot get the numbers to work out correctly. Can someone please help? The 'corect' numbers are calculated manually in column O

Thanks,

Eric.

**Pete_UK** · 06-17-2013, 08:49 AM

I don't see how your attached workbook relates to your question. Did you attach the wrong workbook?

Pete

**seppopovich** · 06-17-2013, 08:56 AM

Okay, that should be it...sorry.

**Pete_UK** · 06-17-2013, 09:22 AM

Put this in M6:

=SUMPRODUCT(J$6:J$15,(INT(H$6:H$15)<=N6)*(I$6:I$15>=N6))

and copy down.

Check some of your numbers in column O.

Hope this helps.

Pete