advanced summaries

[JakeMann]

Hi,

I need to know if an specific type of summary is possible.

On the attached sheet-

Column A shows 2 jobs that are both running in shift 1 and require 2 members of staff to complete each job.

As a general summary that is stating that 4 staff would be required in shift 1.

However, that's not the case as these jobs are run one after the other so the same 2 staff on the first job could do the second.

I need a formula that assess the number of jobs and staff in a shift, and generates a figure that isn't a total number of staff but assesses the staffing requirements and produces a figure that can cover all those requirements.

Not sure how easy that is...