INDIRECT function to reference worksheet

[mckaymmc]

Help please

if have the formula =SUMPRODUCT(INDIRECT("'"&M11&"'!"&($I$12:$I$20)="P")*(INDIRECT("'"&M11&"'!"&B$12:$B$20=($A12&$C12))))

where I am trying to use a vlaue in cell M11 to reference a worksheet called 'HubA' and check various conditions.

The original formulae I use for to reference the worksheet works (below)

=SUMPRODUCT((HubA!$I$12:$I$20="P")*(HubA!B$12:$B$20=($A13&$C13)))

I admit I dont understnad the INDIRECT formula and the syntax, especially all of the " and ' entry's

Thanks

martin

[rylo]

Hi

Try

Please Login or Register  to view this content.

rylo