| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect w/ vlookup = #REF error | Excel Worksheet Functions | |||
| help me(indirect function error) | Excel Programming | |||
| Error when using Indirect | Excel Worksheet Functions | |||
| Error Embedding Row() within Indirect() | Excel Worksheet Functions | |||
| INDIRECT function error | Excel Discussion (Misc queries) | |||
Threaded Mode
