Thread: Indirect - error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kashyap Kashyap is offline
external usenet poster
  
Posts: 131
Default Indirect - error
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")))


Reply With QuoteReply With Quote