=SUMPRODUCT( (INDIRECT(H10&"'!B4:B1000")=B10)
*(INDIRECT(H10&"'!C4:C1000")=C10)
*(INDIRECT(H10&"'!I4:I1000")=$L$1)
*(INDIRECT(H10&"'!G4:G1000"))
)



"Kashyap" wrote:

Hi,

=SUMPRODUCT((Hiren!B4:B1000=B10)*(Hiren!C4:C1000=C 10)*(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:G1 000")))