LookUp Function for a set of Project Dates

[dice78]

Hi there,

I have attached an example workbook for a project timeline I am trying to model:

- Row 8 in Production Profile has a range of drilling rigs that go into operation in the month defined in Row 9
- In the tab Development Schedule I would like to return a (1,0) number if that particular rig is operating in the month defined as above.

I have tried a SumIf function and a Lookup with no success.

Any help greatly appreciated.

[hemesh]

in development sch. sheet in D8 try below drag down and across
=SUMPRODUCT(('Production Profile'!$E$8:$CL$8='Development Schedule'!$B8)*('Production Profile'!$E$9:$CL$9='Development Schedule'!C$6))

[dice78]

Thanks hemesh - appreciated.

[hemesh]

You are welcome!