Please update formula

[srizki]

I am using the following formula,
'=SUMPRODUCT(--(INDIRECT("'"&L$1&"'!$AE$1:$AE$20000")=$A$2)*(INDIRECT("'"&L$1&"'!$AD$1:$AD$20000")=$B2),INDIRECT("'"&L$1&"'!$Y$1:$Y$20000"))

Now I have to use anohter workbook, named,

Data Hrs FY 2011 (8).XLS

how can I update the formula so I can retrive the information needed.

Thanks a lot.

Sohail

 

[Robert Mika]

Maybe like that:
=SUMPRODUCT(--(INDIRECT("'"&L$1&"'!$AE$1:$AE$20")=$A$2),--(INDIRECT("'"&L$1&"'!$AD$1:$AD$20")=$B2),--(INDIRECT("'"&L$1&"'!$Y$1:$Y$20")),--(INDIRECT("'"&K$1&"'!$AE$1:$AE$20")))

where K1 is the name of your new sheet.

 

[srizki]

Thank you Robert, I have not triedd it yet though.

But thanks.

Sohail