indirect-formula error

[kashyap]

[FONT=Verdana, Arial, Helvetica]Hi,
=SUMPRODUCT((Hiren!B4:B1000=B10)*(Hiren!C4:C1000=C10)*(Hiren!I4:I1000=L1)*Hiren!G4:G1000)

I'm trying above formula with indirect as below but I'm not getting result
from below formula..

Where am I going wrong?
=SUMPRODUCT((INDIRECT("'"&H10&"'!B4:B1000"=B10))*(INDIRECT("'"&H10&"'!C4:C1000"=C10))*(INDIRECT("'"&H10&"'!I4:I1000"=$L$1))*(INDIRECT("'"&H10&"'!G4:G1000"))) [/FONT]

 

[DonkeyOte]

The parentheses are slightly awry

=SUMPRODUCT(INDIRECT("'"&H10&"'!B4:B1000")=B10)*....)

The INDIRECT is used to create the range only.

Note: it is also Volatile.

 

[LxQ]

Instead of this:
INDIRECT("'"&H10&"'!B4:B1000"=B10)

use this format:
INDIRECT("'"&H10&"'!B4:B1000")=B10

 

[kashyap]

Thanks both of you..